Your suggestion worked by putting -- in front of the cell.

I have also redone my import mask.

Thank you to everyone for your contributions, this has been annoying me all
day.



"David Biddulph" wrote:

To check whether N2 and J2 are both real dates, try =ISNUMBER(N2) and
=ISNUMBER(J2)
My suspicion is that =ISNUMBER(J2) will be FALSE (and =ISTEXT(J2) would be
TRUE).
You might get away with changing your formula from
=IF(N2<J2,"Early",IF(N2=J2,"On Time","Late"))
to
=IF(N2<--J2,"Early",IF(N2=--J2,"On Time","Late"))
--
David Biddulph


"winnie123" wrote in message
...
Hi,

I have the following formula with which I am trying to calculate if we
have
delivered on time. The result keeps giving me Early and I am not sure why.

=IF(N2<J2,"Early",IF(N2=J2,"On Time","Late"))

Colum N is the Agreed promised Date
Column J is the invoice Date which is an array formula that uses Index and
Match

I have tried to see if the array formula is making the calculation screw
up
my manually entering the date in column J but still get Early as the
answer,
Even though I put a date later than the Agreed Date.

I have checked to make sure Calculation mode is Automatic

Any Ideas on what I have done wrong


Thanks
Winnie