Peo
System date

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Peo Sjoblom" wrote in message
...
Here's my old formula

=IF(TODAY()DATE(YEAR(TODAY()),12,24),"Wait Until After New
Year",DATEDIF(NOW(),DATE(YEAR(TODAY()),12,24),"YM" )&" Month(s),
"&DATEDIF(NOW(),DATE(YEAR(TODAY()),12,24),"MD" )&" Day(s),
"&TEXT(23-HOUR(NOW()),"###")&" Hour(s), "&TEXT(59-MINUTE(NOW()),"###")&"
Minute(s), and "&TEXT(59-SECOND(NOW()),"###")&" Second(s) until
Christmas.")


btw your formula returned "FALSE 6 days 10:25:25" using US Pacific time on
the 19th of Dec current time

mine returned
"0 Month(s), 5 Day(s), 10 Hour(s), 25 Minute(s), and 24 Second(s) until
Christmas."

I haven't really tested mine either so I don't know it is correct overall
since I did it for my kids back in 2002 and I didn't test all
possibilities plus I skipped the time period between Christmas and new
year but at least that day current time it nailed it


--

Regards,

Peo Sjoblom


"Sandy Mann" wrote in message
...
=IF(DATEDIF(TODAY(),DATE(2007,12,25),"ym")=1,DATE DIF(TODAY(),DATE(2007,12,25),"ym")&"
Month"&IF(DATEDIF(TODAY(),DATE(2007,12,25),"ym")," s
",""))&IF(DATEDIF(TODAY(),DATE(2007,12,25),"md")= 1,DATEDIF(TODAY(),DATE(2007,12,25),"md")&"
Day")&IF(DATEDIF(TODAY(),DATE(2007,12,25),"md")1, "s ","
")&TEXT(TODAY()+1-NOW(),"h:mm:ss")

--
Merry Christmas

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"michelle" wrote in message
...
would like to create a worksheet that displays in four cells the number
of
days, hours, minutes, and seconds from now till christmas. should update
automatically. Does anyone know how it can be done?