Formula Issues

Beth Faircloth

Hi Everyone,

I am trying to enter the formula =NETDAYS([Date Submitted]294, [Pre-Site Survey Request Date]294). I receive an amount as long as there is a date in the columns. However, if one of the cells is blank I receive the #INVALID DATA TYPE error. How can I get the =NETDAYS to return a zero if one of the cells is blank. 

Mike Wilday

Hi Beth, 

You can wrap that formula in an IFERROR function like this: 

=IFERROR(NETDAYS([Date Submitted]294, [Pre-Site Survey Request Date]294), 0)

You can also replace the 0 with a text string in quotations... "Date Missing" or something like that to prompt the entry of date if you wanted to. 

Beth Faircloth

Thank you that worked

Mike Wilday

Splendid! I am glad I was able to help you get it working!