=datedif() is documented in xl2k's help (the only version of excel where it IS
documented, actually). But all versions of excel have that function.
Chip Pearson has some very nice notes at:
http://www.cpearson.com/excel/datedif.htm
Dom wrote:
Hi,
I have excel 2000, ain't there, need to upgrade.
Thanx for trying.
"VBA Noob" wrote:
Try this
=DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & "
Months, " & DATEDIF(A1,TODAY(),"MD") & " Days"
--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=562193
--
Dave Peterson