# Adding years to a date [closed]

This post is a wiki. Anyone with karma >75 is welcome to improve it.

This isn't so much of a question, more a possible solution. I was after adding a year to the date in a cell, to mark the end of annual subscriptions, so that 15/03/2012 would become 15/03/2013. What I came up with, courtesy of the function wizard was:

=DATE(YEAR(K2)+1,MONTH(K2),DAY(K2))

Where K2 is the cell coordinate in my sheet. In a date-formatted cell, of course. I thought this might be useful to some folks, and I'm also curious about a simpler solution, if one exists.

Kudos to whoever put the function wizard together, as that's a big help to folk like myself whose spreadsheet skills are a bit rusty.

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2015-10-31 21:25:42.312825

Sort by » oldest newest most voted

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Maybe it is easy the function (according with the help): " EDATE
The result is a date which is a number of months away from the start date. Only months are considered; days are not used for calculation.
Syntax
EDATE(StartDate; Months)
StartDate is a date.
Months is the number of months before (negative) or after (positive) the start date.
Example
What date is one month prior to 3.31.2001?
=EDATE(3.31.2001;-1) returns 2.28.2001.
"

more