number of days between dates?

[Dan B]

Hi,

I need a formula that will calculate the numbers of from today's date (to
update each time the spreadsheet is opened) to a fixed date on the
spreadsheet. It is basically a count down from the current date to a future
date on the spreadsheet.

I guessing the DATEIF function, but I'm not sure how to make it calculate
from the current date.

Thanks!!
Dan

 

[Myrna Larson]

If the fixed date is in A1, =A1-TODAY()

 

[Aladin Akyurek]

=A1-TODAY()

where A1 houses a future date.

 

[HCJ]

Hi Dan,
The TODAY() function returns the current (system)
date. You can do something like =mydate-TODAY() to get
days of difference.

Hope this helps.

 

[HCJ]

Extra note... Sometimes Excel wants to format a formula
like this as Date. A delta of 28 days might show up as
1/28/00. Format the calculation cell as Number instead.

 

[Dan B]

Perfect....Thanks to all!!