I need help with an IF function. Essentially, I have a very simple calculation
=IF(L21, D2-L2, ""). Both the D and L columns are MM/DD/YYYY and the D2-L2 calculation is determining the # of days we are within or outside a deadline. However, in some cases a due date (column D) was not given and therefore in place of the MM/DD/YYYY is "N/A". I can't seem to figure out the proper imbedded multiple IF function that will keep the cell blank or return even a text value. I would be happy with a blank cell or "N/A" just don't want to see "#VALUE!"... any help would be greatly appreciated!