Spot on Year/week_number(s) calculations

[Jeff_Hager]

If you are looking for an explanation of the formula, I break it down in the following post. The formula I gave you is a spin off of the core formula I’ve always used. It’s an old post and I’ve tweaked the math over the years to account for leap years and leap centuries. (None of which matter in your case.) This math has been used by many and proven over the past few years. It’s complex to explain, but makes sense once you take the time to understand it.

If then else with DATE

@Darren_Murphy @Milan_Balogh Geez, I had to put on my thinking cap before my morning coffee. The same place that Darren got that original formula had a second formula. It looks like that old thread is unlisted now, so I won’t link to it, but the second formula dealt with adding years, and also accounted for leap year, so if you added 1 year to Feb 29th, then the next year if would calculated to Feb 28th instead of March 1st. Essentially it would figure out if the month of the future calculate…