Nested IFblank with Networkdays formula



I have a networkdays formula I'm using to calculate that amount of days for 2 dates. Problem is if those cells do not have a date yet I get #INVALID DATA TYPE. Trying to fix this with a IFBLANK or some other formula. Can anyone help? Below is my current formula application and deemed valid are the two columns that may or may not be blank.

=NETWORKDAYS(Application@row, [Deemed Valid]@row)


Best Answer

  • John Pudar
    John Pudar ✭✭✭✭
    edited 08/10/21 Answer ✓

    Hi @Skim,

    If you just want to avoid the error message and keep the cell blank until two dates are entered, this should do the trick:

    =IFERROR(NETWORKDAYS(Application@row, [Deemed Valid]@row), "")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!