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

[datakop]

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]

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?

 

[ryguy7272]

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

 

[Ashish Mathur]

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