Hi,

I need to populate cells within a WorkSheet cell range with dates from a specified period.

The cells to be populated are in the same column. They must display dates from Monday to Friday ONLY.

[u]For Example:</u>
Mon
Tue
Wed
Thur
Fri
Mon
Tue
Wed
Thu
Fri
Mon
Tue
Wed
Thu
Fri

If the start date required is 1st November, 2006 (a Wednesday), is there a method/facility that I can retrieve the dates to populate these cells within the spreadsheet?

[u]To be displayed as:</u>
Null
Null
01-Nov-06
02-Nov-06
03-Nov-06
06-Nov-06
07-Nov-06
08-Nov-06
09-Nov-06
10-Nov-06
13-Nov-06
14-Nov-06
15-Nov-06
16-Nov-06
17-Nov-06

These dates will continue in the WorkSheet to a specfied date (current or future date).

Thanks in advance,







Neal

A Northern Soul

__________________
Neal

A Northern Soul

I have been given 2 pieces of advice, as follows:

1.
Use a formula to populate the dates.
Assuming 1/11/06 is in B3
copy this =IF(WEEKDAY(B3,2)=5,B3+3,B3+1) into B4 and copy down the column.
From A3 down copy this formula =vlookup(WEEKDAY(B3,2),WeekDays,2,false)
Where Weekdays is a named range with two columns as follows
1 Mon
2 Tue
3 Wed
4 Thu
5 Fri

AND...

2.
If you know the first date then type that into the first cell, in the format you want e.g. 01-Nov

Then right-click on the bottom right hand corner of the cell and drag down as far as you want to go. Then select 'Fill Weekdays'.



Neal

A Northern Soul