W
winnie123
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
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