Hello all,
i have a scenario which i am sure is fairly simple to resolve but i have been away from Excel way too long.
I am attempting to calculate the number of days open a ticket was / has been open for a dashboard.
Column A: has opened Date
Column B: Has closed Date.
Colum C: Days Open
Column I: =today()
However not all tickets have been closed and i would like to workout how many days they have been opened for. Is this possible in the same formula?
it feels like a nested if statement, but i am out of my depth here..
Any help would be appreciated.
i have a scenario which i am sure is fairly simple to resolve but i have been away from Excel way too long.
I am attempting to calculate the number of days open a ticket was / has been open for a dashboard.
Column A: has opened Date
Column B: Has closed Date.
Colum C: Days Open
Column I: =today()
opened | closed | days open | 1/5/20 |
1/1/20 | 1/2/20 | 1 | |
1/1/20 | 4 |
However not all tickets have been closed and i would like to workout how many days they have been opened for. Is this possible in the same formula?
it feels like a nested if statement, but i am out of my depth here..
Any help would be appreciated.