You're welcome, Winnie - thanks for feeding back.

Pete

On Aug 11, 3:44*pm, winnie123
wrote:
Pete,

I thinks its the mask I have created to import the records. The date is set
to Charachter and not date format. So will redo my mask and then hopefully it
will work

Thanks



"Pete_UK" wrote:
Perhaps cell N2 has been formatted as Text, so your entry for Agreed
Date looks like a date but isn't.

Hope this helps.

Pete

On Aug 11, 2:44 pm, winnie123
wrote:
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- Hide quoted text -

- Show quoted text -