| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
countdown to date and time
=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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| countdown days,hours,minutes,seconds to a specific date | Excel Discussion (Misc queries) | |||
| Countdown by Date | Excel Worksheet Functions | |||
| Day/Time Countdown | Excel Discussion (Misc queries) | |||
| real-time countdown | Excel Worksheet Functions | |||
| need to show date countdown | Excel Worksheet Functions | |||
Threaded Mode
