Count days between start date and today

Joel Brumback

I want to count the days between the start date and today if the end date is blank.

Paul Newcome

If you want to count from start to end if there is an end but use today if there is no end, then it would look something like this...

=IF(ISDATE([End Date]@row), [End Date]@row, TODAY()) - [Start Date]@row

If you want to leave blank when an end date is present and only count when end date is blank...

=IF([End Date]@row = "", TODAY() - [Start Date]@row)

Paul Newcome

If you want to count from start to end if there is an end but use today if there is no end, then it would look something like this...

=IF(ISDATE([End Date]@row), [End Date]@row, TODAY()) - [Start Date]@row

If you want to leave blank when an end date is present and only count when end date is blank...

=IF([End Date]@row = "", TODAY() - [Start Date]@row)

Joel Brumback

I thought I tried the second one but I must have typed it wrong. Thanks, it worked.

Paul Newcome

Happy to help! 👍️