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

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" <(E-Mail Removed)> wrote in message
news:033CEA26-FFF0-4B84-9D90-(E-Mail Removed)...
> 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?
>

=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 Removed)
Replace @mailinator.com with @tiscali.co.uk


"michelle" <(E-Mail Removed)> wrote in message
news:033CEA26-FFF0-4B84-9D90-(E-Mail Removed)...
> 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?
>
>

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" <(E-Mail Removed)> wrote in message
news:eAwk4fU$(E-Mail Removed)...
> =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 Removed)
> Replace @mailinator.com with @tiscali.co.uk
>
>
> "michelle" <(E-Mail Removed)> wrote in message
> news:033CEA26-FFF0-4B84-9D90-(E-Mail Removed)...
>> 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?
>>
>>
>
>

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 Removed)
Replace @mailinator.com with @tiscali.co.uk


"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:OtKkOkV$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:eAwk4fU$(E-Mail Removed)...
>> =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 Removed)
>> Replace @mailinator.com with @tiscali.co.uk
>>
>>
>> "michelle" <(E-Mail Removed)> wrote in message
>> news:033CEA26-FFF0-4B84-9D90-(E-Mail Removed)...
>>> 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?
>>>
>>>
>>
>>
>
>
>

Peo
System date

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:OtKkOkV$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:eAwk4fU$(E-Mail Removed)...
>> =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 Removed)
>> Replace @mailinator.com with @tiscali.co.uk
>>
>>
>> "michelle" <(E-Mail Removed)> wrote in message
>> news:033CEA26-FFF0-4B84-9D90-(E-Mail Removed)...
>>> 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?
>>>
>>>
>>
>>
>
>