You could also avoid using a formula by putting your date into a cell,
copying it down and then Custom Formatting the cells with this...

dddd, mmm d, yyyy

or any other formatting pattern of your choice.

--
Rick (MVP - Excel)


"Robert Blass" wrote in message
...
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
??

p.s. Using Excel '97