Look he

http://www.cpearson.com/excel/DateTimeWS.htm#NthDoWYear

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sunnyskies" wrote in message ...
| Morning from a cold SA, sunny but temp is +- 10 deg C
|
| Need to show the dates from the Monday of one month to the Monday of the
| next month. This is for a payroll period, thus need to show the dates in
| between the two Mondays (i.e Monday 4th June to Monday 2nd July) so that
| users can capture the respective hours per employee.
|
| Column B would have the respective dates as per the formula, cell B1 would
| have the start date which the data capturer inputs, cell B4 would be the
| first Monday of June and then cell B5 would have the Tuesday and then so on
| until we reach the 2nd July which is the first monday in the new month,
| thereafter the cells should not show any date.
|
| The employees names will be in row 4
|
| Thanks