Formula - OR and dates

Shinano

Board Regular
Joined
Dec 5, 2004
Messages
62
I have the following formula:

=IF((OR(B2="Sunday",B2="Saturday")),0,1)

However, I can not make it work properly.

The cell B2 is a date formatted: mmmm to have it render the day of the week. B2 is based on A2, which is just a regular date formatted: mmmm d, yyyy.

How do I make the above formula recognize that which day of the week is rendered in B2 correctly?

Any advice is highly appreciated.

Thanks a lot.
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Watch MrExcel Video

Forum statistics

Threads
1,113,810
Messages
5,544,425
Members
410,610
Latest member
renatha prado
Top