Hi Steven,
Assuming your dates are in cells D1 and B1 - ( D1 with oldest date ):
=DATEDIF(D1,B1,"Y") & " Years, " & DATEDIF(D1,B1,"YM") & " Months, " &
DATEDIF(D1,B1,"MD") & " Days"
Formula will give your countdown ...
HTH
Cheers
Carim
--
Carim
------------------------------------------------------------------------
Carim's Profile:
http://www.excelforum.com/member.php...o&userid=33259
View this thread:
http://www.excelforum.com/showthread...hreadid=531287