I need help completing an If statement to calculate networkdays when a condition is met

Molly Coop

I have the need to calculate the amount of days a record was open or is currently open. I keep getting errors in the formula. I have the below screen shot for reference.

So, when Progress tracking = complete I need the networkdays from Created to Completed and when Progress tracking <> complete I need the networkdays from Created to Today's date. Any assistance you have is greatly appreciated. :)

Paul Newcome

So you know you want NETWORKDAYS and you want to start from the Created date...

=NETWORKDAYS(DATEONLY(Created@row), stopping point?)

The stopping point for the above you want to read as IF [Progress tracking] is "Complete" then use the [Completed Date], otherwise you want to use TODAY().

=IF([Progress tracking]@row = "Complete", [Completed Date]@row, TODAY())

Now that we have our stopping point established, we can go ahead and drop it into our first bit, and you should be up and running...

=NETWORKDAYS(DATEONLY(Created@row), IF([Progress tracking]@row = "Complete", [Completed Date]@row, TODAY()))

Paul Newcome

So you know you want NETWORKDAYS and you want to start from the Created date...

=NETWORKDAYS(DATEONLY(Created@row), stopping point?)

The stopping point for the above you want to read as IF [Progress tracking] is "Complete" then use the [Completed Date], otherwise you want to use TODAY().

=IF([Progress tracking]@row = "Complete", [Completed Date]@row, TODAY())

Now that we have our stopping point established, we can go ahead and drop it into our first bit, and you should be up and running...

=NETWORKDAYS(DATEONLY(Created@row), IF([Progress tracking]@row = "Complete", [Completed Date]@row, TODAY()))

Molly Coop

Thank you!!!

Paul Newcome

Happy to help! 👍️