CREATE A SUM BASED ON DATES

G

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.
 
R

ronthedog

Hi Gordon - assuming that you've placed the date of the case opening i
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 t
Format Cells and choose Number to display the number of day
difference.

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