Excel - Automatically fill-in dates

March 2017




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.

Related


Published 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 (ccm.net).