Detailed weekly cash flow payments planning

[Crashxtreme]

Hi,
I am currently trying to build a detailed cash flow planning model for the next six months. It is a weekly model. I want to be able to adjust the payment dates for several supplier invoices automatically based on the terms I choose. Can someone help with this?

 

[Crashxtreme]

Here's a link to the file:

Operational Cash Flow Forecast 2021 - SQ V2.xlsx

Week on week CF View for UK UK Cash flow forecast 420,573,1,575,547,745,494,1,235,452,233,52,(2),34,(237),(166) WC 01/11/2021,WC 08/11/2021,WC 15/11/2021,WC 22/11/2021,WC 29/11/2021,WC 06/12/2021,WC 13/12/2021,WC 20/12/2021,WC 27/12/2021,WC 01/01/2022,WC 08/01/2022,WC 15/01/2022,WC 22/01/2022,W...

docs.google.com