Dear Friends
I need a formula to amortize my expenses in below sheet. I want in Column L monthly amortization on the basis, if full month is used then it should calculate for 30 days, if not full month then calculate based on day used in that month.
Days in year base should be 30 days. Kindly...