If cell A1 is the Received date, cell B1 is to contain the number of days
since receipt of the Return receipt, use this formula:

=DATEDIF(A1,TODAY(),"D")

This formula will include the date received but not today in the count (e.g.
from 7/11/2005 to 7/18/2005 gives a result of 7). If you need to count today
as 1 day, add 1 to the format (i.e., +1)

The function TODAY() should update automatically each new day. If not,
check under Tools Options Calculation to see that Calculation is set to
Automatic.

If you want, you can add conditional formatting to the cells in columns B
(e.g make the cell change color when it is equal to greater than 7 days).

"Donna" wrote:

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