nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Networkdays and #invalid data error

hdixon100886

Hoping you can help with the below formula. I need to return zero and can not get the iferror formula to work. current formula is =NETWORKDAYS([Agreement Effective Date]4, [Actual Go Live]4). Screenshot included for reference.

Thanks,

Heather

Find more posts tagged with

Formulas

Comments

Andrée Starå

Hi Heather,

The screenshot doesn't show the columns mentioned.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

hdixon100886

Hi Andree,

The screen shot was attached to my original post. I am looking to replace the error message with a 0 when both date fields are not populated. This will most likely occur in column "actual go live" column.

Thanks,

Heather

Paul Newcome

You can just use an IFERROR statement like this...

=IFERROR(NETWORKDAYS([Agreement Effective Date]4, [Actual Go Live]4), 0)

Andrée Starå

Happy to help!

Try something like.

=IFERROR(NETWORKDAYS([Agreement Effective Date]4, [Actual Go Live]4),0)

Did it work?

hdixon100886

This was perfect. Thank you!

Andrée Starå

Excellent!

Happy to help!

Sign in to join the conversation!

Quick Links

Trending discussions

Start Date Formulas not appearing in reports
Hi community - ran into an issue I've never experienced before. Across all my clients, we use formulas to project dates (we've used durations/predecessors in the past, but it's not our preferred method). If we look specifically at the "TEST - SD - Internal Scope Alignment Call" line, you can see the "Start Date" formula,…
Combine Contact Lists
Hello. I am trying to combine contact list A with the Created By column into one Contact Helper column to use in order to restrict the user view in Dynamic View. Here is my problem. Contact List A is filled in from a form submission. The user is supposed to enter or select their email address along with the emails of any…
Assistance needed with the following formula...
I'm trying to put the correct data (person) in the correct column for an Employee and their Management hierarchy, using the following formula: =IF(VLOOKUP(Worker@row, {Active Workers Report - Mgmt Lvl}, 5, false) = "Team Lead", {Manager}, "") Can someone help me correct the formula, so the Name of the Team…