Hello all,
I am looking for a way to know the interval of days between two dates.
The status of one ticket should pass by different stages and I need to know how many days was the ticket on each status, kindly note that a ticket can repeat the same status, in that case I need to know the summary of the days with same status. so what I need is to know how many days are each ticket in each status.
| TICKET | TIMESTAMP | STATUS |
123 | 2020-01-22 | A |
| 222 | 2020-01-22 | A |
| 123 | 2020-01-23 | B |
| 321 | 2020-01-24 | A |
| 222 | 2020-01-25 | B |
| 123 | 2020-01-25 | B |
| 321 | 2020-01-26 | B |
| 123 | 2020-01-30 | C |
| 321 | 2020-02-02 | C |
Kindly note that Timestamp refers to the date when this information has been entered to the sheet.
With this scenario the results that I want is the below chart. (the numbers in the status columns are days)
| TICKET | STATUS A | STATUS B |
| 123 | 1 | 7 |
| 222 | 3 | 0 |
| 321 | 2 | 7 |
Do you know how can I calculate this ?
Also if you could add a formula to calculate this only in business days will be much appreciated.
Thanks in advance.
