Calculating anniversary dates

Closed
cbbier - Oct 24, 2008 at 09:06 PM
onetera
Posts
7
Registration date
Tuesday October 21, 2008
Status
Member
Last seen
May 16, 2009
- Oct 25, 2008 at 07:02 AM
Hello,

I have a worksheet with several start dates in date format...mm/dd/yy. I want to find the upcoming key anniversary dates (5 years, 10 years, 15 years, 20 years, 25 years, 30 years, 35 years, 40 years, 45 years) of all employees so recognition can be given. I want the actual date to show (mm/dd/yy) so I don't miss recognizing them. I have been able to add the formula for number of years, months and days in one cell. I just need the mm/dd/yy of those key anniversary dates. I will not need the data of those without a key anniversary date.

Thank you.

1 reply

onetera
Posts
7
Registration date
Tuesday October 21, 2008
Status
Member
Last seen
May 16, 2009
2
Oct 25, 2008 at 07:02 AM
hey there,

here is a link which might help you :

http://office.microsoft.com/en-us/access/HA010550721033.aspx?pid=CH011188381033
2