Forum Discussion
Calculating Revenue between Dates
Hello All
We have signed some contracts each of which have their own values, start and end dates. I need to be able to automatically calculate the revenue in respect of these dates.
What formulae is available to automatically calculate the below:
Many thanks
See the attached workbook. The amount per month depends on the actual number of days that fall within that month.
8 Replies
On row 3, you have the contract start on 15th October 2023 and end on 30th June 2024.
You list the first amount in Oct-23, but if that is correct, the duration should be 9 months:
Oct, Nov, Dec. Jan. Feb, Mar, Apr, May, Jun
And the amount should be 200,000/9.
Or do I miss something?
HansVogelaar yes you are correct. Although the reason why the table finishes at March 2024 is because the company operates on a fiscal year, April to March.
Select E2.
Enter the formula
=IF(AND($B2<=EOMONTH(E$1,0),$C2>=E$1),$A2/$D2,"")
Fill to the right to P2, then down.
