Hi all, I am hoping to seek expert advice on how I could create an excel spreadsheet to show projection on cash flow per month.
I have here a spreadsheet, and I wonder if there's any formula I could do
1) to have the cell (I5, P6 etc) to automatically fill up based on the start date.
currently I have done it manually, but if my task start date is changed, I have to manually change the horizontal rows.
2) divide the remaining fund for the rest of the task period. Example G1 cell is the 10% of E4, and I would like to have cell H4 automatically fill up based on the remaining funding up divided equally till the end month of that particular task, in this case H4 up to M4
Thank you very much in advance for your kind advice/attention
Best wishes
Jup
Bookmarks