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