LinkBack URL
About LinkBacks
I am trying to calculate employee tenure. I have the employee start date and the current date - is there a way to get the result to reflect the number of months and days?
I am trying to calculate employee tenure. I have the employee start date and the current date - is there a way to get the result to reflect the number of months and days?
Take a look at the DATEDIF function...
http://www.cpearson.com/excel/datedif.aspx
HTH
Regards, Jeff
Hi pleiadeez7
One way, assuming your start date is in A1:
Formula:
=DATEDIF(A1,TODAY(),"m")&" months "&DATEDIF(A1,TODAY(),"yd")&" days"
Regards Kevin
Merged Cells (They are the work of the devil!!!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks