0
Thanks

A few words of thanks would be greatly appreciated.

Excel - Automatically fill-in dates




Issue


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?

Solution


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).
  • Put the first date in A2 and press the Enter key.

Note


Thanks to sharpman for this tip on the forum.
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Published by . Latest update on by aakai1056.

This document, titled "Excel - Automatically fill-in dates," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).

0 Comments