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.