Forum Discussion
Solved
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 i...
See the attached workbook. The amount per month depends on the actual number of days that fall within that month.
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.