# counting down

Dougal
Guest
Posts: n/a

 18th Aug 2003
I know that I can write =("10/31/03"-"08/18/03") and get
the days between. But I want to create a formula that
would count down the days between these two dates. Can
anyone help?

Guest
Posts: n/a

 18th Aug 2003
Use ="10/31/03" - TODAY()

>-----Original Message-----
>I know that I can write =("10/31/03"-"08/18/03") and get
>the days between. But I want to create a formula that
>would count down the days between these two dates. Can
>anyone help?

Danny
Guest
Posts: n/a

 18th Aug 2003
See Subtracting Dates/Times posted today.

>-----Original Message-----
>I know that I can write =("10/31/03"-"08/18/03") and get
>the days between. But I want to create a formula that
>would count down the days between these two dates. Can
>anyone help?
>.
>

Rob
Guest
Posts: n/a

 18th Aug 2003
Start here. There is a wealth of information on this site:

http://www.cpearson.com/excel/datedif.htm

send Thanks to Mr. Pearson!
>-----Original Message-----
>I know that I can write =("10/31/03"-"08/18/03") and get
>the days between. But I want to create a formula that
>would count down the days between these two dates. Can
>anyone help?
>.
>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Michael via OfficeKB.com Microsoft Excel Misc 7 4th Aug 2005 10:57 PM Michael via OfficeKB.com Microsoft Excel Programming 1 1st Jun 2005 04:10 PM =?Utf-8?B?VEJvZQ==?= Microsoft Excel Misc 9 11th May 2005 11:24 PM David Candy Windows XP General 34 1st Jan 2005 11:27 PM cparsons Microsoft Excel Misc 1 10th Nov 2004 08:12 PM

Features