Tenure Date Formula

adams77 · Aug 2, 2006

I am trying to figure out a formula using today date - start date=
years.months in service. Can someone help me.

Thanks.

Niek Otten · Aug 2, 2006

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| I am trying to figure out a formula using today date - start date=
| years.months in service. Can someone help me.
|
| Thanks.
|
|
| --
| adams77
| ------------------------------------------------------------------------
| adams77's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23695
| View this thread: http://www.excelforum.com/showthread.php?threadid=567485
|

Bob Phillips · Aug 2, 2006

=DATEDIF(start_date,TODAY(),"Y")&" years,
"&DATEDIF(start_date,TODAY(),"YM")&" months"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)