Log In
Register
Home
New Member
November 20, 2020
Offline
I have read the really informative post by Mynda on this topic and asked a question on it, but unfortunately I cannot get Mynda's response to work.
What I need this formula to do is calculate partial months exactly as this formula currently is. Then, be able to treat whole months as equal, instead of dependent on the number of days within this month.
I hope the above explains the issue well enough. The below attachment shows Mynda's formula and what the desired output would be (hard coded of course, as I do not know how to get the formula to do this).
Thanks for your great guides you put out!
Trusted Members
December 20, 2019
Offline
This seems to work
=IFERROR(
IF(MONTH($D5)=MONTH(L4),IF($D5="",0,($G5/($E$3-$D5)*(L$4=MEDIAN(EOMONTH($D5,-1)+1,EOMONTH($E$3,0),L$4))*(MIN($E$3,EOMONTH(L$4,0))-MAX($D5,L$4-1)))),
IF(MONTH($D5)<MONTH(L4),($G5-SUM($I$5:K5))/(12-COUNT($I$4:L4)),
IF(MONTH($D5)>MONTH($M4),0,""))),"")
1 Guest(s)
