How to calculate day rate revenue in the first month, then fixed monthly values (annual / 12)

[beanie3105]

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

 

[Fluff]

Duplicate to: Day Rating calc question

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.