Previous Topic Next Topic

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.
Related:

1 response

Answer 1 / 1
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
calculating fuel surcharge
Nancy -
xpcman -

1 response
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response