Count down to a date

[dacalypsomon]

Good morning,

I need to find the formula for a count down. Can anyone point me in th
right direction?

I want it to look like this:

5 - Daylight Savings Time returns

Thank

 

[Frank Kabel]

Hi
not really sure but maybe something like

Date(2004,3,21) - TODAY()

 

[JE McGimpsey]

One way:

=TEXT(DATE(2004,4,4) - TODAY(),"0") & " - Daylight Savings Time Returns"

 

[Norman Harker]

Hi dacalypsomon!

=DATE(2004,10,31)-TODAY()&" Daylight saving returns"

Date of daylight savings is becoming fairly standardized at last
Sunday in March (for Northern Hemisphere) and last Sunday in October
(for Southern Hemisphere). Switch dates for end of daylight savings

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Norman Harker]

Hi!

Correction: "Date of daylight savings is becoming fairly standardized"

I find that US is changing this weekend.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[dacalypsomon]

Thanks everyone, this is just what I was looking for