W
winnie123
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=J25,"OnTime","Late")),IF(N25="","",(IF(N25+1<J25,"Early",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
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=J25,"OnTime","Late")),IF(N25="","",(IF(N25+1<J25,"Early",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