I am having trouble getting my IF, IFERROR,IFNA statements to not populate #N/A or #Value
Here is my current Formula
=IF(B2="Employee",ABS(F2-M2),IF(B2<>"Employee",ABS(N2-M2)))
the issue i am having is that some of the M and N columns don't have dates. so i am getting #Value populated...