NETWORKDAYS

Trisha

Hi!

I am trying to figure out how to calculate workdays a project is taking. I can do it if I have a start date and end date, but if the end date hasn't populated yet I would like to know how many days it has been so far. You will see the first 3 work fine but I want a formula that will do this and if there is no end date calculate how many days it has been going on. See below

Formula Used: =NETWORKDAY([Date Received]@row, [Agreements Received]@row)

Andrée Starå

Hi @Trisha

I hope you're well and safe!

Try something like this.

=IFERROR(IF([Agreements Received]@row = "", NETWORKDAY([Date Received]@row, TODAY()), NETWORKDAY([Date Received]@row, [Agreements Received]@row)), "")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Ipshita

Hi @Trisha ,

Here is the help for you -

=IFERROR(NETWORKDAYS([Start Date]@row, [Due Date]@row), "")

This would return blank where either your start date or due date are blank cells. Hope this helps!

Cheers :)

Ipshita

Trisha

Thank you! It removed the error but I would like it to populate how many days it has been out if possible until the date is filled in.

Andrée Starå

Hi @Trisha

I hope you're well and safe!

Try something like this.

=IFERROR(IF([Agreements Received]@row = "", NETWORKDAY([Date Received]@row, TODAY()), NETWORKDAY([Date Received]@row, [Agreements Received]@row)), "")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Trisha

Yes! Thank you so much and have a great weekend!

Andrée Starå

@Trisha

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Kathy PPT

Hi @Andrée Starå,

I tried using your last suggested formula above and am getting #unparseable. Hoping you can help, please.

I'm trying to determine the # of days into the project based on today's date and the onboarding start date (when the project actually started) and target end date (when we committed to have the project done). I've changed the order of the fields referenced in all ways but still get same error.

=IFERROR(IF([Target End Date]@row = "", NETWORKDAY([Onboarding Start Date]@row, TODAY()), NETWORKDAY([Target End Date]@row, [Onboarding Start Date]@row)), "")

Thank you,