I have a formula that works, but for cells that should be blank, it shows INVALID DATA TYPE.

A Kempf

I've tried the IFERROR and that is not working.

It's a simple formula to count the dates between when the Case Manager was supposed to sign the form, to when they did sign the form.

=NETWORKDAYS([Document Signed Date]@row, [Document Signature Required Date]@row)

As soon as I make it a column formula, it shows all the cells as INVALID DATA TYPE.

The IFERROR formula isn't working:

=IFERROR(=NETWORKDAYS([Document Signed Date]@row, [Document Signature Required Date]@row, ""))

This results in INCORRECT ARGUMENT.

Nic Larsen

I had an extra parenthesis in the formula. I edited. Try this.

=IFERROR(NETWORKDAYS([Document Signed Date]@row, [Document Signature Required Date]@row), "")

Nic Larsen

Try:

=IFERROR(NETWORKDAYS([Document Signed Date]@row, [Document Signature Required Date]@row), "")

A Kempf

I copied and pasted that into the cell… now it says #UNPARSEABLE.

Nic Larsen

I had an extra parenthesis in the formula. I edited. Try this.

=IFERROR(NETWORKDAYS([Document Signed Date]@row, [Document Signature Required Date]@row), "")

A Kempf

That took away the error, but it's still not filling in the cell. It's just empty.

The Document signed date is empty. The Due Date is filled. So it should be counting the number of days from the Due Date until now. But it's just empty.

Nic Larsen

It sounds like you have two date columns but only one has a date? It will need a date (start and end) in both to work. It doesn't default a TODAY date. You'd have to build in an IF to look for an empty cell and then run it using the TODAY function, but if filled, then go with your original formula.

A Kempf

Yes, awesome, it works now and there is no text in the other fields. Thank you!