with your date in A1

=DATE(YEAR(A1)+3,MONTH(A1),DAY(A1))


--

Regards,

Peo Sjoblom

"NWO" wrote in message
...
Hello.

I have a situation where I need to calculate a date out three years from a
given start date. For example, I have a date, say 6/8/2005, and I want to
know what the three year anniversay date is from this date, to inlcude
compensating for leap years. I have played with the date functions and
tried
to formulate a formula to solve this, but to no avail. Any ideas would be
helpful.

Thank you.

NWO.