Invalid Data Type when Date column empty
I'm using the formula below to calculate the NETWORKDAYS
between the date an invoice was submitted until it is paid, if it has not been paid it calculates the NETWORKDAYS with TODAY. The formula is working, however, I'm getting an error on every row that does not have a date sent for payment yet. Is there a way to add IFERROR to this?
=IF(ISBLANK([Invoice Paid]@row), NETWORKDAYS([Date Sent for Payment]@row, TODAY()), NETWORKDAYS([Date Sent for Payment]@row, [Invoice Paid]@row))
Help Article Resources
Check out the Formula Handbook template!