Hi,

Am Mon, 4 Nov 2013 17:23:44 +0000 schrieb JFELLOW:

=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".

try:
=IF(L2*D2<0,D2-L2,"")


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2