• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need Formula help

Dee

Member
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?
 
Back
Top