If the hire date was 2/29/2008 what would be the 1yr anniversary date?

--
Biff
Microsoft Excel MVP


"Jugglertwo" wrote in message
...
I'm trying to figure out how to have my employees' anniversaries be
figured
in Excel to show the dates.
1) A2 has the person's hire date.
2) I would like to be able to figure out their 1st, 5th, 10th-40th
anniversary dates.
3) B2-1st anniversary, C2-5th anniversary date, etc.
4) A2 would be hire date of 3/28/2005. I want B2 to be their 1st
anniversary
of 3/28/2006.
5) I want C2 to be their 5th anniversary of 3/28/2010.
6) d2-10th,e2-15th,..........40th
I have read several of the other posts but can't figure it out for what I
want to do.
Any assistance would be greatly appreciated ! Thanks!
Jugglertwo