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