counting down

[Dougal]

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?

 

[Brad E]

Use ="10/31/03" - TODAY()

 

[Danny]

See Subtracting Dates/Times posted today.

 

[Rob]

Start here. There is a wealth of information on this site:

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

send Thanks to Mr. Pearson!