Sorry your new formula is confusing.. However I have got two suggestions

1. Is R25 a text value or date? If R25 is a date you can use the WEEKDAY()
function which returns the day of the week. 5 would be Thursday..
=IF(AND(WEEKDAY(R25)=5,N25<""),N25+4,"")

2. Your new formula has got a syntax problem.. Where do the OR condition
stop. I dont see the closing braces for the OR condition.
=IF(N25="","",IF(OR(R25="Thursday",N25+4<J25),"Ear ly",IF(N25+4=J25,"OnTime","Late")))

If you can respond with the sample values in the cells and your expected
results for the sample values; it would be easy to understand...

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


"winnie123" wrote:

Hello,

I have the following formula which is currently resulting in an error. It is
checking the shiped date in column N and adding 1 day on against the agreed
despatch date.

IF(OR(R25="Thursday",N25+4<J25,"Early",IF(N25+4=J2 5,"OnTime","Late")),IF(N25="","",(IF(N25+1<J25,"Ea rly",IF(N25+1=J25,"OnTime","Late")))))


Basically I want to check if Cell R25 has a Thursday date and if so add 4
days onto N25, also if N25 does not have any value to return as blank.

Any suggestions please?

Thanks
Winnie