problem with an "if" statement

Hello guys, I am having trouble with this " if" statement and would like some advise.

=IF((A31="Saturday,Sunday"),"",1234)

Cell A31 is a day & date formatted cell like this Sunday, 13 Sep , 2015 . When the date occurs in A31 is Monday through Sunday the the statement results in false. I need to understand why the statement does not read the day part of the A31.

I hope you can understand where I am coming from. Please raise and question with me if unclear.

Thank you..

Hi, welcome to the forum.

You need to understand something about how Excel deals with dates: all dates are stored as serial numbers, not as the dates themselves - so 13 Sep is '42260' (1 Jan 1900 is '1'). So it doesn't 'understand' that you're searching for Sat or Sun. Try this instead, which checks if the date is a Saturday (weekday 7) or Sunday (weekday 1):

Formula:

=IF(OR(WEEKDAY(A31)=7,WEEKDAY(A31)=1),"",1234)

That assumes your system settings have Sunday as the first day of the week - if you get incorrect answers, try 6 & 7 instead of 7 & 1.

Hope that helps.

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.

Thank you Aardigspooks this works perfectly. Now that the front end of my formula works I can carry on trying to create the backend.
Many thanks you are a diamond...