Forum Discussion
Dates in Spreadsheet
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 ...
Sorry. That is not working for me. Thank you, though.
In what way doesn't it work?
How about
=EDATE(cell_with_date, 120)
(10 years = 120 months)
- THAT worked! Thanks, Hans!