Auto fill dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a time sheet with a 'date' column for entry from a1 - a7. Once the
first date in a1 is entered (mm-dd-yy) is there a way to have the remaining
cells auto fill the sequence of dates?
 
Just add 1 to the previous date. So, in cell A2, enter: =A1+1

Or, if you want cells A2-A7 to remain blank until a date is entered in A1,
then use this formula:

=IF(ISBLANK(A1),"",A1+1)

HTH,
Elkar
 
Back
Top