CREATE A SUM BASED ON DATES
 

I am A MP and I am trying to create an excell doc that will track the time
that has elasped from the date a case is open to the present date is this
even possible. thanks for any help. For example a case was entered on date
"A" and it has been 49 days sence that date.

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