Forum Discussion
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 dat...
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])