Financial Monthly Forecast

[Andre24]

Hi community of greater intelect than myself :P

I have a complex set of requirements that I am unable to solve. I've used various solved threads formulas and got as far as i could on my own, and hope you'll be able to help me please.

Please see attached Help Request spreadsheet.

1) Standing Orders Tab - Collumn J - I want to auto populate Collumn J down with the monthly recurring dates like collumns F, H & I are doing. The same day, but recurring months. Currently is only counting up in single days, and i can't figure out how to do months instead.
2) Is it necessary to do it this way? This may be a long-winded way to auto-populate the Dynamic Standing Orders Forecast in the Overview Tab.
3)When auto-populating Standing Order Forecast, is there a way to move it to the next working day if it happens to fall on a weekend?
4)With the Standing Orders Tab and all the future recurring dates populated there, is Collumns F, M & T required in the Overview Tab? Or is there a way to calculate the current months day value if an start date is entered instead? thus removing the requirement for Standing Orders Tab?

Apologies, I have thrown several complex questions out here, hopefully some of them are answerable.

Any and all help will be greatly appreciated.

[JeteMc]

Hello Andre24 and Welcome to Excel Forum.
As to 1 and 3, try:

Please Login or Register  to view this content.

Acknowledgement to Ron Coderre who shared a formula from which I borrowed (stole) the idea for this one.
Note that the range O2:O10 is set aside for the dates of holidays if any.
Let us know if you have any questions.

[Andre24]

JeteMc,

Legendary, works a treat!!

Thank you

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.