How to calculate # of days to the future from TODAY

C

cardingtr

Hello, how to calculate the number of days between today and a future
date entered in a certain cell?

I want to put the number of days "to go" before deadline.


Thanks.
Ric
 
B

Biff

Hi!

Just subtract today from the future date:

A1 = future date = 1/1/2007

=A1-TODAY()

Format the formula cell as GENERAL.

Once the future date has passed the result will be negative.

Biff
 
S

Sandy Mann

Simply subtract the two dates and format as General or Number

--
HTH

Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 

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

days calculation 3
If formula with dates 4
number of months and days between two dates without approximation 3
Display weeks from a Milestone 0
Conditional formatting with dates 7
Two formulas in one cell? 4
Need help with an IF Function 4
How to replace a constant from a cell containing date and time 1

Top