Awesome!, exactly what I needed.
--
Thanks!
-Jennifer


"Elkar" wrote:

> 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