Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
add a hire date to the end of year (12/31/05) and get Total years
I need to determine how many years employees have been here. I know the
start date (example 6/02/98) At the end of this year (12/31/2005) this person has been here 7 1/2 years. What is the formula to have excel figure this, and display it in number form 7 1/2 or 7.5. |