Forum Discussion
Solved
Building dynamic date for Loan Amortization Scheduler
Hi, I am using excel 365 and trying to build Loan Amortization Scheduler. I am trying to get date as dynamically such as Yearly, Half Yearly, Quarterly, Monthly, Bi weekly and even weekly. My qu...
You will need two alternative formulas, depending on whether the frequency is an exact multiple of days or months,
= startDate + SEQUENCE(nper,1,0,frequencyDays) = EDATE(startDate, SEQUENCE(nper,1,0,FrequencyMonths))
You will need two alternative formulas, depending on whether the frequency is an exact multiple of days or months,
= startDate + SEQUENCE(nper,1,0,frequencyDays)
= EDATE(startDate, SEQUENCE(nper,1,0,FrequencyMonths))