Bob, you could try this
A2 =NOW()
B2 = future date e.g. 25-Dec-2006
C2 =INT(B2-A2)
D2 =INT((B2-A2-C2)*24)
E2 =MOD(INT((B2-A2)*1440),60)
F2 =MOD(INT((B2-A2)*86400),60)
C2:F2 gives you days hours minutes and seconds between your now and
your date
to update automatically you need VBA - see Joe Was contribution here
http://www.mrexcel.com/board2/viewtopic.php?t=98916
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=506642