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.

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

"BrendaP" wrote:

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.

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

"Sean Timmons" wrote:

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

"BrendaP" wrote:

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.

Have you tried
=today()-a2
copied down

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"BrendaP" wrote in message
...
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.

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

"Don Guillett" wrote:

Have you tried
=today()-a2
copied down

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"BrendaP" wrote in message
...
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.

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"BrendaP" wrote in message
...
I did, it will not work. Thanks for your help though :)

"Don Guillett" wrote:

Have you tried
=today()-a2
copied down

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"BrendaP" wrote in message
...
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.

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

"BrendaP" wrote:

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

"Don Guillett" wrote:

Have you tried
=today()-a2
copied down

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"BrendaP" wrote in message
...
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.

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"BrendaP" wrote in message
...
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.