View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim
 
Posts: n/a
Default Can this be done


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