Is it possible to calculate future dates based on the nth occurrence of a day of the week in a given month? For example, I would like to return the dates the 1st Monday in April falls in 2023, 2024, etc.
Yes it is definitely possible. I have written formulas like this in the past and even posted them on the forums. It is easiest to calculate the dates like the first Monday, or last Friday. Trying to calculate things like the second Monday or the third Thursday are harder.
I don't have time to re-write the formula, and the search on the new forums is not robust enough for me to be able to find my previous posts where I included these formulas.
