Can anyone come up with ONE formula that with choose the 2nd OR 4th Monday, depending on a particular "Start Date".
For example...
If the start date falls between Tuesday, July 26, 2022 - Sunday August 7th, 2022, the formula would pick Monday, August 8, 2022 (2nd Monday of the month).
However, if the start date falls between Tuesday, August 9, 2022 - Sunday, August 21, 2022, the SAME formula would pick Monday, August 22, 2022 (4th Monday of month).
Then again, if the start date falls between Tuesday, August 23, 2022 - Sunday, September 11, 2022, the formula would pick Monday, September 12, 2022 (2nd Monday of the month), and so forth and so forth....
In my many attempts, I kept getting "the next Monday,
and not the 2nd or 4th Monday.
For example...
If the start date falls between Tuesday, July 26, 2022 - Sunday August 7th, 2022, the formula would pick Monday, August 8, 2022 (2nd Monday of the month).
However, if the start date falls between Tuesday, August 9, 2022 - Sunday, August 21, 2022, the SAME formula would pick Monday, August 22, 2022 (4th Monday of month).
Then again, if the start date falls between Tuesday, August 23, 2022 - Sunday, September 11, 2022, the formula would pick Monday, September 12, 2022 (2nd Monday of the month), and so forth and so forth....
In my many attempts, I kept getting "the next Monday,
and not the 2nd or 4th Monday.