Dates in Spreadsheet

[VonnieGoodVBG]

How can I add 10 years from a cell in a new cell?  As in, I have 11/1/12 in a cell and I want to make that 11/1/22 in the next cell?  So, I have a much of rows with a date and I want to add 10 years to the next cell?

[#2]

@VonnieGoodVBG 

=DATE(YEAR(D2)+10,MONTH(D2),DAY(D2))

You can try this formula.

[#3]

Sorry. That is not working for me. Thank you, though.

[#4]

@VonnieGoodVBG 

In what way doesn't it work?

How about

=EDATE(cell_with_date, 120)

(10 years = 120 months)

[#5]

THAT worked! Thanks, Hans!