Have revenue distributed between two years. How to calculate the carryover revenue with given start date of the project assuming project affected for 12 months
Start date = 03/08/2017(MM/DD/YYYY format)
End date = DATE(YEAR(Start),MONTH(Start)+11,1)
Gross Savings = 12000
Monthly savings = Gross Savings/12
Result should be 2017 revenue = 10000
2018 revenue = 2000
Can formula experts help me on this?
Start date = 03/08/2017(MM/DD/YYYY format)
End date = DATE(YEAR(Start),MONTH(Start)+11,1)
Gross Savings = 12000
Monthly savings = Gross Savings/12
Result should be 2017 revenue = 10000
2018 revenue = 2000
Can formula experts help me on this?