Website
How to allocate an amount evenly across months based on a start
- end date.
by Alex Magnin
(1 total)
“How to allocate an amount evenly across months based on a start - end date. First, calculate amount per day, then: =$AC3*((MAX(O$2-$J3,0)-MAX(EOMONTH(O$2,-1)-$J3,0))-(MAX(O$2-$K3,0)-MAX(EOMONTH(O$2,-1)-$K3,0))+(EOMONTH(O$2,0)=EOMONTH($J3,0)))”
— Alex Magnin, twitter.com