Hi Gordon - assuming that you've placed the date of the case opening in
cell A1 you could use the following formula

=TODAY()-a1

where TODAY() will return todays date.

Excel will probably format the formula result as a date, but go to
Format Cells and choose Number to display the number of days
difference.

As I'm sure you know, Excel stores dates as numbers starting from 1 for
1 January 1900 to 38,587 for today and this is how you can simply
subtract one from the other to get a date difference.


--
ronthedog
------------------------------------------------------------------------
ronthedog's Profile: http://www.excelforum.com/member.php...o&userid=26504
View this thread: http://www.excelforum.com/showthread...hreadid=398069