Hi,

Looks like O35 is actually a date formatted as dddd and not text so try this:

=iF(AND(WEEKDAY(O35) =1,R35T25),T25,R35)


HTH
Jean-Guy


"kevcar40" wrote:

O35 = Sunday

T25 = 06:00:00

R 35 = End time of fault ie 05:21:00

What i want to do is check cell O35, if it is sunday and the end time
is after 06:00:00 i want the end value to be 06:00:00 or if the end
time is before 06:00:00 i want the end time to equal r 35

i am trying this formula
iF(AND(O35 ="Sunday",R35T25),T25,R35)
but getting nowhere
can anyone help please

thanks

kevin