close
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
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),quot;quot;,A1 1)
HTH,
Elkarquot;Jenniferquot; wrote:
gt; I have a time sheet with a 'date' column for entry from a1 - a7. Once the
gt; first date in a1 is entered (mm-dd-yy) is there a way to have the remaining
gt; cells auto fill the sequence of dates?
gt; --
gt; Thanks!
gt; -Jennifer
全站熱搜
留言列表
