Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Formula - Compute Number of Years Worked
I am using Excel 2002. I have a simple spreadsheet that
shows; Employee Name Employee Hire Date Smith, Ann 08/14/2001 Is there a formula that I can write that will automatically compute how many years an employee has worked? I do not need it date specific as much as month specific. i.e. I would like to know all emloyees that have a hire date in August and how many years they have worked for our company through August. |
#2
|
|||
|
|||
Hi,
=YEAR(TODAY())-YEAR(A1) Where A1 is the cell housing your Hire Date. HTH -- Regards, Zack Barresse, aka firefytr "Penny" wrote in message ... I am using Excel 2002. I have a simple spreadsheet that shows; Employee Name Employee Hire Date Smith, Ann 08/14/2001 Is there a formula that I can write that will automatically compute how many years an employee has worked? I do not need it date specific as much as month specific. i.e. I would like to know all emloyees that have a hire date in August and how many years they have worked for our company through August. |
#3
|
|||
|
|||
Take a look at Chip Pearson's notes at:
http://www.cpearson.com/excel/datedif.htm Penny wrote: I am using Excel 2002. I have a simple spreadsheet that shows; Employee Name Employee Hire Date Smith, Ann 08/14/2001 Is there a formula that I can write that will automatically compute how many years an employee has worked? I do not need it date specific as much as month specific. i.e. I would like to know all emloyees that have a hire date in August and how many years they have worked for our company through August. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
Excel Calculation Error for formula to sum | Excel Discussion (Misc queries) | |||
Excel formula randomly changes to hard-code number | Excel Discussion (Misc queries) | |||
Excel formula divide list of #s by N to get a number above 40 | Excel Discussion (Misc queries) | |||
Looking for function or formula to calculate number that is revers | Excel Worksheet Functions |