Years and Weeks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Michael, have a look here
http://www.cpearson.com/excel/datedif.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

Michael said:
I would like to type an employee's start date and today's date and then
Click to expand...
have in another cell tell me how many years and weeks that employee worked.
Can I do this?
 
= Int((DateLast - DateFirst) / 365.25) & ":" & Int(((DateLast - DateFirst) /
365.25 - Int((DateLast - DateFirst) / 365.25)) * 12)


Michael said:
I would like to type an employee's start date and today's date and then
Click to expand...
have in another cell tell me how many years and weeks that employee worked.
Can I do this?
 
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?
Click to expand...


=DATEDIF(B20,TODAY(),"y")&" yrs and "&
INT(DATEDIF(B20,TODAY(),"yd")/7)&" weeks"

Will give the number of whole years and full weeks since the employment date
(with the employment date in B20).

If you want to round the weeks to the closest, change the INT function to
ROUND(DATEDIF.....,0)


--ron
 
Back
Top