Ask Your Question
1

Adding years to a date [closed]

asked 2013-05-13 21:42:21 +0100

this post is marked as community wiki

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 flag offensive 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

1 Answer

Sort by » oldest newest most voted
2

answered 2013-05-13 22:10:19 +0100

this post is marked as community wiki

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.
"

edit flag offensive delete link more

Comments

So for instance, subscription date in A3, Ending date in B3 with the formula =edate(A3,24) for a two year subscription. of course you could also have a length of subscription cell with a companion cell that converted it to months and use that in the place of the "24".

Jim7fl gravatar imageJim7fl ( 2013-11-12 14:19:43 +0100 )edit

Question Tools

Stats

Asked: 2013-05-13 21:42:21 +0100

Seen: 4,107 times

Last updated: May 13 '13