beanie3105
New Member
- Joined
- Dec 21, 2016
- Messages
- 18
Hello
We only pro rate revenue if it starts mid month, the middle months will then be (if it's annual for example) the total divided by 12, the remaining released in the last month. This is system generated and i'm trying to prove it out in excel - what is the best formula to be able to calculate date rating if it starts mid month, but then change to a fixed monthly value
We only pro rate revenue if it starts mid month, the middle months will then be (if it's annual for example) the total divided by 12, the remaining released in the last month. This is system generated and i'm trying to prove it out in excel - what is the best formula to be able to calculate date rating if it starts mid month, but then change to a fixed monthly value