NetworkDay formula condition question

Kathy PPT

I'm looking for guidance please and appreciate any input!

I was able to get the NETWORKDAY formula to work by itself. However, I am now trying to put a condition to calculate NETWORDAY if the Project Status is not "Complete". Otherwise, I want it to display the Duration field. It's not erroring, just says the format is not correct.

All these fields are in the Intake sheet

Paul Newcome

Try adding another closing parenthesis after the TODAY() function.

Kathy PPT

@Paul Newcome - Unfortunately, that didn't work. I tried that and then putting parenthesis around [Duration]. I keep getting syntax is wrong.

This original formula does work: =NETWORKDAY([Onboarding Start Date]@row, TODAY())

I appreciate your time/help. Have a great weekend.

Paul Newcome

Based on the new screenshot, it looks like your cell references are missing a row indicator.

[Project Status]@row

Duration@row