Assuming ColumnA is your date, try this:

=VALUE(A12)-VALUE(TODAY()) (Be sure cell format is General)


Hope this helps.



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


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=388066