IF OR Statements

[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

 

[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)

 

[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