Search : in
By :

Calculating anniversary dates

Last answer on Oct 25, 2008 12:02:16 pm BST cbbier, on Oct 25, 2008 2:06:58 am BST 
 Report this message to moderators

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.

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « calculating anniversary dates » in :
Backup Outlook 2003 data ShowBackup Outlook 2003 data All Outlook 2003 data ( Emails, Agenda, Contacts, Tasks...) are in one file with .pst extension The file is in the following default folder: C:\Documents and Settings\Login\Local Settings\Application...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Backup/Restore Mysql database ShowBackup/Restore Mysql database Backup Restore your database Note A simple approach on how to backup and restore MySQL databases. Backup To save an existing database it is recommended that you create a dump. To dump all...
Download The Love Calculator ShowLove is a big word, then all means are good to find it. The name of each can say about it on compatibility between two persons a lot. The Love Calculator is a program which counting affinity between two individuals. It is not a precise science,...
Download N1bus Calculator Show
Download Simply Contacts Database Show
Data transmission - Cabling ShowCabling types Several physical data-transmission media are available to connect together the various devices on a network. One possibility is to use cables. There are many types of cables, but the most common are: Coaxial cable Double twisted...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Data transmission - The physical connection ShowWhat is a transmission channel? A transmission line is a connection between two machines. The term transmitter generally refers to the machine that sends the data while receiver refers to the one receiving the data. The machines can sometimes be...
Ask your question Reply

1

 onetera, on Oct 25, 2008 12:02:16 pm BST
   
Reply to onetera
Ask your question Reply
They need your help