Date formula
=DATEDIF(F1,TODAY(),"Y")&" years, "&DATEDIF(F1,TODAY(),"YM")&" months
"&DATEDIF(F1,TODAY(),"MD")&" days"
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Richard" wrote in message
...
If F1 has a hire date, how would you write the formula to show the number
of
years, months, and days in F2, something like today()-F1 or now()-F1. I
can't
get it to show the total years, months and days.
Thanks in advance!
|