How to Calculate Days Late Using Today’s Date When End Date is Missing?

System

This discussion was created from comments split from: Formula for delay between target and actual end date.

Robin H 77

How can I use this formula, or similar, if some of my rows do not yet have an end date, and the days late needs to be calculated based on today's date instead?

Paul Newcome

@Robin H 77 Give something like this a try:

=NETWORKDAYS([Start Date]@row, IF([End Date]@row <> "", [End Date]@row, TODAY()))

Robin H 77

How can I use this formula, or similar, if some of my rows do not yet have an end date, and the days late needs to be calculated based on today's date instead?

Michelle Choate 2

[Days Late Column Formula] =IF(ISBLANK([End Date]@row), Today() - [Target End Date]@row,

Then the second part of the formula would be if it is not blank, then you want to calculate based off of the end date for days late?

IF([End Date]@row <>"", Today() - [End Date]@row,

Is this what you are thinking?

Paul Newcome

@Robin H 77 Give something like this a try:

=NETWORKDAYS([Start Date]@row, IF([End Date]@row <> "", [End Date]@row, TODAY()))

Robin H 77

Paul, thank you!!

Paul Newcome

Happy to help. 👍️