In one column I have the hire date of our employees, in the column next to it I would like to calculate how long the person has been here.
Name | Hire Date | Time Hired
Joe |7-15-07 | 4mths 1day
Sue | 5-26-99 | 8yrs 5mths 21days
something to this effect.
thank you for your advice and help in advance.
Try this,
DATEDIF(B2,NOW( ),"y") & " years, " & DATEDIF(B2,NOW( ),"ym") & " months, " & DATEDIF(B2,NOW( ),"md") & " days"
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
many thanks that worked like a charm!
Glad to hear it - thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks