# How do I add 2 years to a date field?

#### gavia111

##### New Member
I'm trying to add two years to a date type in Excel. I specifically do not want to just add 730 days as it doesn't account for leap years. Please advise.

Thanks! :D

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

#### 2rrs

##### Active Member
Hi,

You could use this; you need to make sure that the Analysis Tool Pak in turned on.

=EDATE(A12,24)

2rrs

#### yesterday

##### New Member
Column A has your original dates:
=DATE(YEAR(A1)+2,MONTH(A1),DAY(A1))

#### gavia111

##### New Member
Worked great thanks!

Now is there a way I can subtract today's date for a day in the future and determine the number of days in between? For example if monday is 03/24/03 and today is 03/20/01 the number of days between the two dates is 735. How can I calculate this?

Thanks so much for the help!

##### MrExcel MVP
gavia111 said:
Worked great thanks!

Now is there a way I can subtract today's date for a day in the future and determine the number of days in between? For example if monday is 03/24/03 and today is 03/20/01 the number of days between the two dates is 735. How can I calculate this?

Thanks so much for the help!

=A1-TODAY()

A1 houses a value like 03/24/03, a true date. Format the formula cell as General.

Replies
3
Views
53
Replies
7
Views
83
Replies
6
Views
127
Replies
12
Views
182
Replies
7
Views
48