number of days between dates?

  • Thread starter Thread starter Dan B
  • Start date Start date
D

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need help with a Function 0
Excel Message box with days of month & date. 1
Count number of dates between a specified period of time 2
Calculating total number of days 3
Has @DAYS 360 function calculated differently between qtr and mon 1
DATEIF 1
CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY 4
Formula Returning Records # of Days from Today in Excel 2

Back
Top