#INVALID DATA TYPE error on NETDAYS function
I am trying to find the number of days between two dates - a due date, and a paid date. I used the formula =NETDAYS([Due Date]@row, [Cleared Date]@row). This worked for a good chunk of the cells, but not others. The remaining cells are returning the #INVALID DATA TYPE error.
I've already ensured both the Due Date row and the Cleared Date row are set under Column Properties as Date.
I have also tried doing the Cleared Date minus the Due Date and receive an error on the same cells - #INVALID OPERATION.
Also, I have already checked that the Cleared Date is AFTER the Due Date, so that shouldn't be the issue. I couldn't find any answers searching the community. Any help on this would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!