Payment Period: To give End Date (mm/dd/yy) given the Start Date and Months

[ladyoutdoor]

What formula to use, my formula gives a wrong result. =DATE(YEAR(A1),MONTH(A1)+E1,DAY(A1))
Start date of Payment - Jan 05, 2019
Months to Pay - 6 Months
No. of Payments - 12
End Date of Payment Should be - June 20, 2019 but when I use the formula its giving me a result of JULY 5, 2019

Need help how to fix the formula, thanks.

 

[MPaul100]

January is 1 month. 1+6=7, therefore July.
If all payments are set on every 20th of the month, then you will need something like: =DATE(YEAR(A1),MONTH(A1)+E1-1,20)