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


"Jennifer" wrote:

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?
--
Thanks!
-Jennifer