calculating time

[Guest]

I would like to have a formula that would total the number of years and weeks an employee work by me entering the start date and todays date. Can I do this?

 

[Jim]

This gives you mare than you asked for, but it's one way:

=DATEDIF(C1,TODAY(),"y")&" years"&", "&DATEDIF(C1,TODAY(),"ym")&" months"&",
"&DATEDIF(C1,TODAY(),"md")&" days"

Where the Start Date is in C1
--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays

I would like to have a formula that would total the number of years and

weeks an employee work by me entering the start date and todays date. Can I
do this?

 

[Ron Rosenfeld]

I would like to have a formula that would total the number of years and weeks an employee work by me entering the start date and todays date. 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