Almost but how does it stop at the first Monday of the next month?

"Mike H" wrote:

Hi I'm not sure what level of automation you want in this but the simplest
way to do it is have your person put the date (must be 1st of the month) in
B1 and then this formula in B4 which will calculate the first Monday of the
date in B1

=IF(WEEKDAY(B1,3)0,7-WEEKDAY(B1,3),0)+B1

In B5 you then simply enter =B4+1 and drag down as far as you require.

Mike

"Sunnyskies" wrote:

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