=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" <[email protected]> wrote in message
news:[email protected]...
> 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
Bookmarks