How do I add 2 years to a date field?

gavia111

New Member
Joined
Mar 20, 2003
Messages
2
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
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

2rrs

Active Member
Joined
Dec 25, 2002
Messages
346
Hi,

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

=EDATE(A12,24)

2rrs
 

gavia111

New Member
Joined
Mar 20, 2003
Messages
2
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!
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,192
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,918
Messages
5,525,623
Members
409,657
Latest member
19JimRon72

This Week's Hot Topics

Top