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.