adding 1 year to a date in Excel

Question

adding 1 year to a date in Excel

Anonymous

Hi, I am creating an excel program that calculates when licenses need to be renewed. The calculation needs to add one year to the date in the original cell. The fact that there are not always the same # of days in a month or year does not matter.

Example: A1 B1

5/1/2017 5/1/2018

Any suggestions?

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

2 additional answers

Answer 1

Try below formula, it adds one year:

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

Another option is to add 12 months:

=EDATE(A2,12)

Difference between the above formulas is that if date in A2 = 29th Feb 2016 (leap year), then the first formula returns 1st March 2017 while the second formula returns 28th Feb 2017.

Regards,

Amit Tandon

www.globaliconnect.com

http://twitter.com/AmitTandonExcel