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.
For Example:
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?
To be displayed as:
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,