How To INCREMENT days of the week? like mon,tues,wed,etc??
Robert Blass wrote...
Is there is a function or process where you can increment the days of
the week AS WELL as the date?
Like
Monday Aug 1, 2009
Tuesday Aug 2, 2009
etc..
or even JUST the days of the week?
like
Monday
Tuesday
Wednesday
etc
??
Something like entering the following formula into cell A1.
A1:
=TEXT("Jul 31, 2009"+ROW(),"dddd mmm d, yyyy")
Then fill A1 down into A2:A30 or so.
|