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.
Custom Future Date Calculation
+8
+29Yes 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.
+8Yes 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.
Yeah. As always, I tried a search before posting with no luck. I stopped after reviewing 15 of 700+ screens before giving up. Sigh…😳
Can you give me a hint about your approach to the problem? I can't quite wrap my head around it.
+8Anyone? Anyone? Bueller?
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.