Hi,
I am trying to use a formula to calculate the deferred revenue of sales that have a 2 or 3 year subscription period. Forecast of new sales start every month from Sept 2018 thru to Dec 2019 and I need to show how the deferred revenue is pushed out into the years 2018 onwards
I have uploaded a table of the data I am forecasting. In cells V5:ad10 i want the number here to represent what I can recognise in different years
Appreciate any help
Thanks
Bookmarks