countdown to date and time

M

michelle

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

FC

I've working on it and so far I got how many MONTHS and DAYS left, if you
want it let me know.
 
P

Peo Sjoblom

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 @
 
S

Sandy Mann

=IF(DATEDIF(TODAY(),DATE(2007,12,25),"ym")>=1,DATEDIF(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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
P

Peo Sjoblom

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
 
S

Sandy Mann

Doh! I never read properly what the OP asked for - four cells! Days,
Hours, Minutes & Seconds

=IF(TODAY()>DATE(YEAR(TODAY()),12,24),DATEDIF(TODAY(),DATE(YEAR(TODAY())+1,12,25),"yd"),DATEDIF(TODAY(),DATE(YEAR(TODAY()),12,25),"yd"))&"
Day"&IF(TODAY()=DATE(YEAR(TODAY()),12,24),"","s")

=TEXT(TODAY()+1-NOW(),"h")&" hour"&IF(TEXT(TODAY()+1-NOW(),"h")="1","","s")

=MID(TEXT(TODAY()+1-NOW(),"h:m"),SEARCH(":",TEXT(TODAY()+1-NOW(),"h:m"))+1,3)&"
minute"&IF(TEXT(TODAY()+1-NOW(),"mm")="1","","s")

=TEXT(TODAY()+1-NOW(),"s")&"
second"&IF(TEXT(TODAY()+1-NOW(),"s")="1","","s")

From Christmas Day it gives the number of days until the following
Christmas.

--

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top