counting down

's Computer Specifications

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?

's Computer Specifications

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?

's Computer Specifications

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

's Computer Specifications

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
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Counting rows, then counting values.	Michael via OfficeKB.com	Microsoft Excel Misc	7	4th Aug 2005 10:57 PM
Counting Rows Then Counting Values in Columns	Michael via OfficeKB.com	Microsoft Excel Programming	1	1st Jun 2005 04:10 PM
Counting names in a column but counting duplicate names once	=?Utf-8?B?VEJvZQ==?=	Microsoft Excel Misc	9	11th May 2005 11:24 PM
12,000 and counting - dead, 1 Million and counting - homeless	David Candy	Windows XP General	34	1st Jan 2005 11:27 PM
counting rows counting empty rows	cparsons	Microsoft Excel Misc	1	10th Nov 2004 08:12 PM