Forum Discussion
formula for next annual interest due date
ello, I am trying to automatically update next interest due date on annual basis with following parameters Issue Date Maturity Date Today date Next Interest Due Date Previous Interest...
Let's say Issue Date is in A2, Maturity Date in B2 and Today's Date in C2.
If you have Microsoft 365 or Office 2021, enter the following formula in D2.
=LET(d,DATE(YEAR(C2),MONTH(A2),DAY(A2)),e,EDATE(d,12*(d<C2)),IF(e>B2,"",e))
And in E2:
=LET(d,DATE(YEAR(C2),MONTH(A2),DAY(A2)),e,EDATE(d,-12*(d>=C2)),IF(e>B2,"",e))
Format D2 and E2 as dates.
This can be filled down if needed.