HELP! Automatically spread revenue over the next few months after due date

[crystaldo1301]

Hi all,

My problem situation is that our business is running a number of projects simultaneously and their closed dates are different. I would like the revenue of the whole project to be automatically recognized and distributed evenly over the next 5 months, with the first revenue inflow is on the following month after the closed date (e.g. closed date is on June 2015, then the first revenue amount will be recognized on July 2015).

An Excel spreadsheet with some data to clarify my problem. I would like to turn those amount from E1 to W7 into formula so that it can populate by itself, not manually.

Thanks heaps.

[azumi]

Perhaps something like this?

[crystaldo1301]

Hi Azumi,

Thanks a lot. The formula is such a complex one, but it works perfectly as what I want. Thanks again

[azumi]

thanks for feedback, comeback anytime...........