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 response

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