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!

Try datedif function, see here

http://www.cpearson.com/excel/datedif.htm


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=514571

=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!

Try...

=DATEDIF(F1,TODAY(),"Y")&" Years, "&DATEDIF(F1,TODAY(),"YM")&" Months,
"&DATEDIF(F1,TODAY(),"MD")&" Days"

Hope this helps!

In article ,
"Richard" wrote:

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!

=DATEDIF(F1,NOW(),"y") & " years, " & DATEDIF(F1,NOW(),"ym") & " months, " &
DATEDIF(F1,NOW(),"md") & " days"


"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!