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..
Bookmarks