Count Networkdays to TODAY only when End Date not listed?

BFuller

Hello,

How can I calculate networkdays to TODAY only when the end date is not populated? The following formulas work, but I can't figure out how to stop the counting of networkdays when the review end date is populated. I need to set some alerts when projects enter review and are not completed and the alerts are based on the number of days in the review period.

Thanks!

=NETWORKDAYS([SME Draft 1 Review Start Date]@row, TODAY(0), {Holidays})

=IFERROR(NETWORKDAYS([SME Draft 1 Review Start Date]@row, [SME Draft 1 Review End Date]@row, {Holidays}), "")

Paul Newcome

You would use an IF statement in the second portion of the NETWORKDAYS function to output the End Date if it is not blank or TODAY() if it is blank.

=NETWORKDAYS([SME Draft 1 Review Start Date]@row, IF([SME Draft 1 Review End Date]@row <> "", [SME Draft 1 Review End Date]@row, TODAY()), {Holidays})