I am trying to calculate the next due date for a periodic payment based on a starting date and a the current date.
e.g.:
Start date 1/1/2021 Today's date is 16/4/2021 when is the next monthly payment due
Start date 1/1/2021 Today's date is 16/4/2021 when is the next annual payment due
Start date 1/1/2021 Today's date is 16/4/2021 when is the next fortnightly payment due
Start date 1/1/2021 Today's date is 16/4/2021 when is the next quarterly payment due
I have a solution for monthly payments but cannot translate that to annual, fortnight or quarterly.
A1: =TODAY()
A2: 1/1/2021
A3: =DATE(YEAR(A1),IF(DAY(A2)>DAY(A1),MONTH(A2)+1,MONTH(A2)),DAY(A1))
e.g.:
Start date 1/1/2021 Today's date is 16/4/2021 when is the next monthly payment due
Start date 1/1/2021 Today's date is 16/4/2021 when is the next annual payment due
Start date 1/1/2021 Today's date is 16/4/2021 when is the next fortnightly payment due
Start date 1/1/2021 Today's date is 16/4/2021 when is the next quarterly payment due
I have a solution for monthly payments but cannot translate that to annual, fortnight or quarterly.
A1: =TODAY()
A2: 1/1/2021
A3: =DATE(YEAR(A1),IF(DAY(A2)>DAY(A1),MONTH(A2)+1,MONTH(A2)),DAY(A1))