IF OR Statements

D

donkey77

I have list of days of the week (Sunday - Saturday) and am looking t
define them as weekday or weekend. I was wondering how to set up
formula to identify this. I figure it is something like:

IF = Saturday then =weekend
IF = Monday then = weekday

and so on.

Thanks in advanc
 
B

Bob Phillips

=IF(OR(A1="Saturday",A1="Sunday"),"Weekend","Weekday")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
S

Stan Scott

If you really have the day of the week stored in cell A1, then use this
formula:

=IF(OR(A1="Saturday",A1="Sunday"),"weekend","weekday")

Stan
 
Top