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

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!