Hello, I am using a formula that works to calculate the number of working days left to the Original or Revised Due date:
=IF([Revised Due Date]@row = "", NETWORKDAYS(TODAY(), [Original Due Date]@row), IF([Revised Due Date]@row <> "", NETWORKDAYS(TODAY(), [Revised Due Date]@row)))
but I would like to add a condition: If the task is Complete, then the working Days left is Blank (or -) but not carrying counting.
Please can someone help,
Help Article Resources
Check out the Formula Handbook template!