inserting date

[paul_pearson]

I enter a date into C4 (always a Monday).Is there a formula or VBA Code which then inserts daily dates from Monday to Friday into the following cells...C4:C8 (dates 17/6/2013 to 21/6/2013) , C12:C16 (dates 24/6/2013 to 28/6/2013) etc,,,etc,, with dates to 21/12/2013

No weekend dates required only Monday to Friday

Thanks

Paul

 

[paul_pearson]

I am using the code from post #27 and it work great...is it possible to have 4 rows between weeks instead of the 3....

Are you able to put a password / message box on the VBA code for deleting the dates...

Also can the code be altered so that you must enter a date C4 before running the Enter Dates macro

Thanks again

Paul