Hi

Does anyone have any suggestions for a macro that would fill dates dow
on a spreadsheet based upon the certain dates entered on a differen
sheet? For example on Sheet 1:

Cell A1 - Start Date - 1/1/2005
Cell A2 - End Date - 7/31/05

These dates vary & change all the time so I would like a Macro to loo
at these dates and on Sheet 2:

Column A1 - Fill down all rows(212 days from 1/1/05 to 7/31/05) wit
the range of dates on sheet 1(Cell A1 to A2).
Column B1 - Copy the Formula ( =TEXT(WEEKDAY(A2),"dddd")) in Column
based on the number of rows generated from the start to the end dat
(212 rows from 1/1/05 tp 7/31/05).

Any help would be greatly appreciated!

Thank

--
STEVE
-----------------------------------------------------------------------
STEVEB's Profile: http://www.excelforum.com/member.php...nfo&userid=187
View this thread: http://www.excelforum.com/showthread.php?threadid=38997