Date Formula for number of days between a date and today

[BrendaP]

I need to be abble to calculate the number of days between a date and
today-The fomat is Dates going down the rows in column "A" and I need the
days since that date to go down the rows in column "B". I want this to be
able to automatically update to todays date when I opent he sheet. What I
don't want to have to do is have a column with the function/formula "Today"
in it just to get this to work. Any help would be appreciated.

 

[Sean Timmons]

Not sure what you mean you don't want a column with TODAY() in it. You would
need soemthing that pulls the TODAY() or NOW() function to get today's date.
Are you wanting TODAY() to be only in a single cell?

If so, you can put TODAY() in, say, C2. Then in B2, you'd enter =$C$2-A2 and
paste down, formatting column B as dd

 

[Don Guillett]

Have you tried
=today()-a2
copied down

 

[Bernard Liengme]

If A1 holds a date, then this formula in B1
=A1-TODAY()
will tell you how far away the date is.
However, being ever so helpful, Excel will likely format B1 as a date. You
will need to format it General (just once after entering the formula) Then
you can copy it down the column

I'm afraid I have to use TODAY() as I know no other way
What is your objection to it?
best wishes

 

[BrendaP]

I did, it will not work. Thanks for your help though

 

[BrendaP]

Can the "TODAY" function be included in a formula or is it just a stand alone
function?

 

[Bernard Liengme]

If the formula did "not work" (you did not tell us what result you got),
then one suspects that the cells do not contain real dates. What happens if
you use the formula =A1+1 (assuming A1 holds the first date)? Do you get the
date of the next day?
best wishes

 

[Sean Timmons]

the below formula does work, but may need to check to make sure your
calculation is set to automatic (Tools>Options>calculation>Automatic) and
your column is formatted as Number...