countdown to date and time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
I've working on it and so far I got how many MONTHS and DAYS left, if you
want it let me know.
 
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 @
 
=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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top