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