Forum Discussion

mdamerau's avatar
mdamerau
Occasional Reader
Jun 05, 2025

Calculating ticket days open

For active tickets, I have an open (start) date, but no end date, and need to calculate days open based on today's date.  Is there a way that Excel can use current date instead of a specified end date? 

BI & Data Analysis
Excel on Mac
Formulas and Functions

1 Reply

Sort By
  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Jun 05, 2025

    yes you can use TODAY() so something like TODAY()-[start_date] but if you will have an end date at some point you can use =IF( [end_date]<>"", [end_date], TODAY() ) - [start_date]

    and if you have rows without a start date then wrap in another IF:

    =IF([start_date]="","", IF( [end_date]<>"", [end_date], TODAY() ) - [start_date])

    or

    =IFS([start_date]="","", [end_date]<>"", [end_date] - [start_date], TRUE, TODAY()  - [start_date])

Resources