Thread: Years and Weeks
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
ZootRot[_2_] ZootRot[_2_] is offline
external usenet poster
 
Posts: 3
Default Years and Weeks

= Int((DateLast - DateFirst) / 365.25) & ":" & Int(((DateLast - DateFirst) /
365.25 - Int((DateLast - DateFirst) / 365.25)) * 12)


"Michael" wrote in message
...
I would like to type an employee's start date and today's date and then

have in another cell tell me how many years and weeks that employee worked.
Can I do this?