For just the days of the week...

You can enter Monday in the first cell then just drag down and Excel will
increment them.

If you want a formula:

=TEXT(ROWS(A$1:A2),"dddd")

Copy down

For the days and the date, it depends on what dates you want.

--
Biff
Microsoft Excel MVP


"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