Duration of a project
I have been calculating the duration of a project in the column excluding weekends and I have been using this simple formula
=NETWORKDAYS([Date Sent IKA/CHD]@row, [Date Closed]@row)
It has worked but if the project is on going and there is no entry in "date closed" column then it populates the column with an error message. Is there a way to use this formula with a "If" statement so that if there is a close date to use that and if not to use the current date to show the ongoing duration days?
Help Article Resources
Check out the Formula Handbook template!