On Mon, 18 Jul 2005 09:24:02 -0700, "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


If rcvd date is in column A (starting in row 1), and forumla is in
column B, enter this:

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

MP-
--
"Learning is a behavior that results from consequences."
B.F. Skinner