if formula not working on date comparison

  • Thread starter Thread starter steven knight
  • Start date Start date
S

steven knight

HI,

I need to calculate days diff but only when the payment date is before
the mailed date.

Problem is the formula : =IF(D3<E3,DATEDIF(D3,E3,"D"),0) only seems to
work on some cells.

If i have a payment date of (D3) 08/06/04 and a mail date of (E3)
28/05/05
this results in #NUM result instead of 0, so the if condition is not
giving
me the result i need which should be 0.

Any ideas ?

Regards
 
Your formula works for me. Perhaps you have some of the
dates formated as text and not as date. For example if I
enter 28/05/05 as text the results will be #NUM. Check
your formatting.

Charlie O'Neill
 
Back
Top