Cash Flow Forecast/Retirement Planner Change Start Month


Is there a way to change start month for these two templates?

In the Cash Flow Forecast solution, M2 is showing the cash flow from 1/1/2021 to 12/31/2021. Is there a way to display cash flow from 7/1/2021 to 6/30/2022 instead?

Great question, @roger.chu91 !

@randy or @jono , ideas on this one? I’m not familiar enough with those solutions yet.


Sorry, @roger.chu91, but right now this template is built around calendar years. This change is definitely doable though if you’re feeling confident and dig into the formulas.

Hi @roger.chu91 ,
As @randy noted, the sheet is built assuming calendar years.

But, check out the notes in the hidden part of the sheet in column AE starting in row 14.

Date ranges can be overridden.

Note that if you select a date range that is less than 12 months, the budget numbers will be annualized based on the months in the date range.

Note also that overriding the start and end months will mostly affect the initial budget period. The years will still be listed in column L without any month reference. Life event will be included based on whether they match the year’s range.

The sheet assumes the year starts Jan 1, but if you assume your years start on a different date, and keep that system for all your data input, I think it should work ok. This hasn’t been tested though.