IF ERROR Help

Heather Dixon

Hi all,

I am trying to create a formula where I am getting an invalid data error message when dates are not populated.  Below is the beginning of my formula:

=NETWORKDAYS([Phase Start Date]44, [Phase End Date]48)

I am trying to add a 0 if there is an error, however I'm missing something in the formula:

=NETWORKDAYS([Phase Start Date]44, [Phase End Date]48), IFERROR([Days to Complete]49:[Days to Complete]97,0)

 

TIA!

Heather

 

Mike Wilday

Do you want the zero to be added after the number of workdays or in place of it? It's a little confusing what you are requesting. Can you show us what you'd expect in a screenshot from your formula?

Heather Dixon

Hi Mike,

Since there is an error being returned because 1 or both of the date columns do not have a value I would like for the return to be 0. I included two screen shots - one with the return, and one with the error message returned.

 

Image attached

Heather Dixon

Sorry the first date column should have the "Discovery" date highlighted, and then the second date column is correctly highlighted.  Purpose is to determine how many days between Discovery and Go Live.

Mike Wilday

Okay so you can wrap the formula in an iferror tag... 

=Iferror(=NETWORKDAYS([Phase Start Date]44, [Phase End Date]48),0)

Should do the trick. 

Heather Dixon

Soo   I feel like this is Monday LOL....I adding the formula to the appropriate rows and it now returns a "0" for all returns.

Heather Dixon

I was able to get this one to work!!  Thanks Mike

Correction is 

=Iferror(NETWORKDAYS([Phase Start Date]44, [Phase End Date]48),0)

Mike Wilday

Whoops. Yep, I accidentally included the equals sign in front of networkdsays! Glad I could help you out.