If dates spent at previous company were, say, C4 to D4

=DATEDIF(C4,TODAY()-E4+D4,"Y")&" years, " &
DATEDIF(C4,TODAY()-E4+D4,"ym")&" months, " &
DATEDIF(C4,TODAY()-E4+D4,"md")&" days"


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