calculating time

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

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?
 
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
Michael said:
I would like to have a formula that would total the number of years and
Click to expand...
weeks an employee work by me entering the start date and todays date. Can I
do this?
 
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?
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