1st, 5th, 10th, 15th Anniversary dates for employees base on Hire
 

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

1st, 5th, 10th, 15th Anniversary dates for employees base on Hire
 

Hi,

Try this in b2 for the first anniversary date

=DATE(YEAR(A2)+1,MONTH(A2),DAY(A2))

and for the 5th

=DATE(YEAR(A2)+5,MONTH(A2),DAY(A2))

I guess you can work the rest out.

Mike

"Jugglertwo" wrote:

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

1st, 5th, 10th, 15th Anniversary dates for employees base on Hire
 

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

1st, 5th, 10th, 15th Anniversary dates for employees base on H
 

Mike:
Thanks for much for the formula. It is exactly what I was looking for.
I owe you one.
Thanks again!
Jugglertwo

"Mike H" wrote:

Hi,

Try this in b2 for the first anniversary date

=DATE(YEAR(A2)+1,MONTH(A2),DAY(A2))

and for the 5th

=DATE(YEAR(A2)+5,MONTH(A2),DAY(A2))

I guess you can work the rest out.

Mike

"Jugglertwo" wrote:

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