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.