I want to calculate how many Days/Hours/Minutes/Seconds between Now and
a future date

eg how many Days/Hours/Minutes/Seconds between Now and 08:25 on 9th
September 2005

I have used the formula below

=(INT(B7-TODAY())-(MOD(B7,1)-MOD(NOW(),1)<0))&" Days
"&TEXT(MOD(B7-NOW(),1),"hh")&" Hours "&TEXT(MOD(D6-NOW(),1),"mm") &"
Minutes "&TEXT(MOD(D6-NOW(),1),"ss") &" Seconds "

This returns the result 32 Days 14 Hours 01 Minutes 58 Seconds , which
is wrong as there are 34 Days until 9th September, what is wrong with my
formula?

When I F9 to update only the seconds are changing

Second question is there any way to automate this so that it counts
down on the screen without having to recalculate

Paul


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=393641