=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?