Hi All.
I am trying to build a formula that will evenly spread an project order value over a number of months based on the project duration and win date
Duration could be 1 - 60 months
Revenue starts in month following order month
values are inserted automatically.
default is zero
section of spread sheet attached - values have been entered manually at this stage
Bookmarks