How To INCREMENT days of the week? like mon,tues,wed,etc??

[Robert Blass]

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

 

[Harlan Grove]

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.

 

[Rick Rothstein]

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.

 

[T. Valko]

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.

 

[Shane Devenshire]

Hi,

1. enter the first date
2. format it to dddd mmm d, yyyy custom format - choose Format, Cells,
Number tab, Custom, and enter the above codes in the Type box, click OK.
3. Drag the fill handle down - the bottom right corner square on the cell
with the date.

If you only want weekdays -
4. Open the paste options drops down (small clipboard icon at the bottom
left of the filled range), and choose Weekdays

If this helps, please click the Yes button

Cheers,
Shane Devenshire