calc. an anniversary date(50 years) after marriage date in excel
 

I need to be able to accurately calculate an anniversary date. For example I
need to add 50 years to the marriage date e.g October 22 1960 and get October
22nd 2010.

Just adding 18,250 days does not do it. I guess, I need to take account of
leap years?

Thanks

Duncan

calc. an anniversary date(50 years) after marriage date in excel
 

Or let excel handle it.

If A1 contains the date: Oct 22, 1960
You could use:
=date(year(a1)+50,month(a1),day(a1))
(format the cell as a date)

And you'd be done.

There would be a problem with a date like Feb 29. 50 years in the future won't
be a leap year.

If you're concerned about that, what date should be used: Feb 28 or Mar 1?



datakop wrote:

I need to be able to accurately calculate an anniversary date. For example I
need to add 50 years to the marriage date e.g October 22 1960 and get October
22nd 2010.

Just adding 18,250 days does not do it. I guess, I need to take account of
leap years?

Thanks

Duncan

--

Dave Peterson

calc. an anniversary date(50 years) after marriage date in excel
 

So, just do this: =365.25*50
There are 365.25 days in a year and 50 years and multiply.

http://en.wikipedia.org/wiki/Year

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"datakop" wrote:

I need to be able to accurately calculate an anniversary date. For example I
need to add 50 years to the marriage date e.g October 22 1960 and get October
22nd 2010.

Just adding 18,250 days does not do it. I guess, I need to take account of
leap years?

Thanks

Duncan

calc. an anniversary date(50 years) after marriage date in excel
 

Hi,

You could also try this

=edate(A2,50*12)

A2 has the marriage date. If you get the NAME error, then please install
the Analysis Toolpak from Tools Addins

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"datakop" wrote in message
...
I need to be able to accurately calculate an anniversary date. For example
I
need to add 50 years to the marriage date e.g October 22 1960 and get
October
22nd 2010.

Just adding 18,250 days does not do it. I guess, I need to take account of
leap years?

Thanks

Duncan