=TODAY()-A2

You could also use conditional formatting to see if the time exceeds 7 days.
See http://www.xldynamic.com/source/xld.CF.html#basic

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Donna" wrote in message
...
I would like to know how to write the formula so that I can calculate the
number of days from received date. Received date is a column and the
formula
is in another column. When I open the spreadsheet first thing in the
morning, it should change all the numbers. I have to wait 7 days from
receipt of Return receipt of Registered mail before I can send to County
Attorney. I need this column to tell me it is time to process legally.
Can
anyone help?

Thanks
Donna