Nested IFblank with Networkdays formula

Skim

Hello,

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)

Thanks,

John Pudar

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), "")

John Pudar

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), "")

Skim

Wow this is my first question ever asked. That totally worked, appreciate your help.

Thanks John!