| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
countdown to date and time
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countdown to date and time
I've working on it and so far I got how many MONTHS and DAYS left, if you
want it let me know. "michelle" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countdown to date and time
Michelle,
I have a workbook I created some years ago that I can send you if you want? It's not exactly 4 cells but it displays it like this 3 Month(s), 2 Day(s), 12 Hour(s), 32 Minute(s), and 52 Second(s) until Christmas. Send an email to: Aterre08NOSPAMgmail.com remove A and replace NOSPAM with @ -- Regards, Peo Sjoblom "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? |
|
#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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countdown to date and time
Doh! Apologize, I sent the message in the future because I forgot to change
the damned date back again. I have cancelled the message but it obviously will only work on the MS server -- 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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countdown to date and time
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? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countdown to date and time
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? |
| Reply |
| 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 | |||
Linear Mode
