How to make date auto forward [Solved/Closed]

Report
-
 rothi -
Hello,

I'm trying to figure out how - after entering a date in a cell- to get the following dates to automatically fill in.

For example: when creating a log that requires daily entries once I type 12/01/09 into the first cell, (say, "A 1") how can I hit "Enter" and have 12/02/09 automatically fill in "A2" cell, then hit "Enter" again and have 12/03/09 automatically fill in "A3" cell without having to type each date on each line?


Thanks for any info you can share to enlighten me on this issue!

Valorie

2 replies

Posts
1023
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
243
Try this. assuming you have excel 2007.

assuming A2 is the start of your Log.

Put this formula in A3
=IF(ISBLANK($A$2),"",SUM(A2+1))


Then copy the formula that is in A3 to all the subsequent A's following A3. (or as far as you need to go.

This will in effect fill in the dates in all the following 'A' Cells as soon as you hit enter after putting a date in A2.

Hope this helps
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3256 users have said thank you to us this month

plz give me code to auto generate date and id using C#.