CREATE A SUM BASED ON DATES

[Gordon.Ferguson]

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.

[ronthedog]

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.