Hi,
I have the following formula to subtract the dates from two different
columns:
=IF(DATEDIF(Z11,AD11,"m")=0,"",DATEDIF(Z11,AD11,"m "))

What i want the formula to do is to calculate the differnce between the two
dates. However, if there is nothing entered into the columns, then i want the
column that's calculating the difference to remain blank. And this is working
great. Until i enter in a date into Z11 but not into AD11. Then it gives me
the "=NUM!" error instead of remaining blank.