Who's up for this challenge?
based on a Thursday start date...
I need ONE formula to always pick the next FIRST Monday of a month (that falls on a FULL week***)...whether it be this month or next.
Example:
if start date is Thursday November 3rd, 2022, the formula would choose Monday, November 7th, 2022.
However, if start date is Thursday, November 10th, 2022 (or 17th, or 24th), then the formula would choose Monday, December 5th, 2022.
I need ONE formula, that will factor either circumstance.
*** Note: Nov. 1st is on a Tuesday ... the first FULL week in November is the following week (11/6 - 11/12).
The same for Dec. 1st falls on a Thursday, therefore the first FULL week in December is the following week (12-4 - 12/10)
I need the Mondays that fall within the first FULL week.
based on a Thursday start date...
I need ONE formula to always pick the next FIRST Monday of a month (that falls on a FULL week***)...whether it be this month or next.
Example:
if start date is Thursday November 3rd, 2022, the formula would choose Monday, November 7th, 2022.
However, if start date is Thursday, November 10th, 2022 (or 17th, or 24th), then the formula would choose Monday, December 5th, 2022.
I need ONE formula, that will factor either circumstance.
*** Note: Nov. 1st is on a Tuesday ... the first FULL week in November is the following week (11/6 - 11/12).
The same for Dec. 1st falls on a Thursday, therefore the first FULL week in December is the following week (12-4 - 12/10)
I need the Mondays that fall within the first FULL week.