NETWORKDAYS formula with future dates
I am trying to work up a NETWORKDAYS formula to calculate "Days Active", either calculating between the Approved Launch Date and Close Date, or Approved Launch Date and TODAY(), if the Close Date cell is blank(basically, stop counting the days once the close date is entered).
I managed to use the following:
=IF(ISBLANK([Close Date]@row), NETWORKDAYS([Approved Launch Date]@row, TODAY()), NETWORKDAYS([Approved Launch Date]@row, [Close Date]@row))
which works, unless the Approved Launch Date is in the future, at which point I get a negative number.
How should I modify this formula to return "0" if the Approved Launch Date is in the future?
Also, if there is a simpler way to organize the base formula above, I'd love to see examples.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!