Hi, I'm trying to write a formula to calculate rent payment commitment between two dates. Please see attached for details.
Thanks
Abs
Hi, I'm trying to write a formula to calculate rent payment commitment between two dates. Please see attached for details.
Thanks
Abs
Re: Formula to show rental payments due on monthly, quarterly and annual basis
Hi,
Not sure to fully understand ... :wink:
However, a formula to be tested :
=IFERROR((DATEDIF(MAX(O$3-1,$L$2,EOMONTH($K6,-1)),MIN(O$4,$C6),"m")/$H6)*$F6,0)
HTH
Re: Formula to show rental payments due on monthly, quarterly and annual basis
Hi Carim, thanks for that.
I've developed the formulas further for quarterly payments as well. However it doesn't work on some of the dates. On some rows it adds in an extra month or quarter in the first year and on some rows in adds in and extra month/quarter on the year the contract finishes.
The assumption in all cases is that payment is in advance.
Grateful if you could have a look at the attached for me.
Thanks in advance.
Abdul
Don’t have an account yet? Register yourself now and be a part of our community!