Years and Weeks

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

 

[Paul B]

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

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?

 

[ZootRot]

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

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?

 

[Ron Rosenfeld]

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?

=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