Excel: Add month to previous date incrementally, giving same date for all months

I am trying to sequential dates over a period of months based on the given input date.

Current excel formula: =--(MONTH(B2+32) & "/" & DAY(B$2) & "/" & YEAR(B2+32))

Input date format: DD-MM-YYYY

Version: Microsoft office Home and Student 2019

Can someone please provide the excel formula for this?

2 Answers

Use the EDATE function:

Returns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date). Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.

=EDATE(B2,1)

With the start date in A1
Type this in A2:
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
(fill down)

Expected to work in all Excel, Libreoffice and OpenOffice versions.