“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)))”
More from Alex Magnin
“Messaging has resisted traditional, interrupted advertising for a very obvious reason: It…”
“=INDEX(A:A,(ROW()-1)*5+1)”
“=SUMIF(D5:D27," <>#N/A")”
“What publishers should think about is what data they can create that no one else can, how…”