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.