Need help with showing cost for future years

[xozelda11]

Currently forecasted data is provided by month and report is updated on a monthly basis using report date so if report date < the forecasted month date then it would be considered actuals, anything greater than the report date would be considered forecast using the formulas below to determine total cost (spent + forecast)

YTD Cost = 

Future Forecast:

Spent: 

However, if I wanted to show the forecast for future years ex. 2024+, this formula would not work because everything would be considered spent since I am adding 2024, 2025, 2026 data using this formula. How do I add future forecast data without messing up the formula for 2023? 

YTD Spent = 5M

YTD Spent + Fcst = 90M (5M for actuals + 85M forecasted)

In order to not mess with the current year, I had to add a separate tab called Cost (+5) years, which shows up as blank for 2023, unless the year 2024, 2025, 2026, etc. is toggled to show the forecast for those years. 

How it is currently set up for years 2024+ we don't have it by month so I just put everything in december:

Is there a way to utilize the current formulas above to show the forecasted years without it messing up the current year (2023) actuals/forecasted data?