I am having great difficulty with a leap year with respect to the formulas you see in the attached Xl2bb examples.
In the sheet ForecastHistory2023 you will see all the formulas are working correct, but in the sheet ForecastHistory2024 the initial formulas in C5 & C6 and probably consequently...