Help

Custom Future Date Calculation

3441 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Darryl_Oliver
6 - Interface Innovator
6 - Interface Innovator

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.

3 Replies 3

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.

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.

Darryl_Oliver
6 - Interface Innovator
6 - Interface Innovator

Anyone? Anyone? Bueller?