Thanks I think the problem must be with the mask I have created to import the
data.

"Jacob Skaria" wrote:

I am not sure whether this will work..(as desired)

--Can you pre-format the fields to date format...

--OR try the formula..(again depends on the text format of the date text
format)
=IF(DATEVALUE(N2)<DATEVALUE(J2),"Early",IF(N2=J2," On Time","Late"))

If this post helps click Yes
---------------
Jacob Skaria


"winnie123" wrote:

Hi Jacob,

I created a new worksheet and entered the dates with Ctrl + semicolan and
the formula works.

Why is that??

The dates are currently imported from the network system we use. I have set
both columns to date format.

How can I overcome this without having to manually enter the dates?

Thanks for your assistance

"Jacob Skaria" wrote:

Are the dates in date format. Can you try this formula in a new worksheet.
Enter the dates using Ctrl + semicolon and then edit.

If this post helps click Yes
---------------
Jacob Skaria


"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