Sequence the date and add a year according to a specific cell

[sofas]

Hello, I use this formula to sequence the date, conditional on cell b2, with the addition of a month. I want to modify the formula to add a year.

Automatically fill rows with dates based on cell value

MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share them everywhere.

www.mediafire.com

 

[Joe4]

The EDATE function add months to a specific date.
A year is just 12 months, so you can multiply the number by 12 to increment years instead of months, i.e.

EDATE($A$4;ROW(A1)*12)

 

[sofas]

The EDATE function add months to a specific date.
A year is just 12 months, so you can multiply the number by 12 to increment years instead of months, i.e.

EDATE($A$4;ROW(A1)*12)

Thank you. This is what is really required

 

[Joe4]

You are welcome.
Glad I was able to help!