IF weekday then > If Saturday then...

[Badvgood]

Me again...

To simplify it, I am stuck on a formula that states:

IF A6 is a weekday then 1, IF A6 is a Saturday, then 2, IF A6 is a Sunday, then ""

Thanks BVG

[jeffreybrown]

Hi BVG,

How about >> =IF(OR(TEXT(A6,"ddd")={"Sat","Sun"}),2,1)

[Badvgood]

Thanks but this still displays Saturdays and Sundays both as 2, it fails to display Sundays as 0 zero or blank.

Thanks BVG

[jeffreybrown]

Please Login or Register  to view this content.

Maybe you need to elaborate on this even more. "then what"

[Badvgood]

Sure, then either blank "" or zero etc would be perfect.

Thank you for assisting.

Kind regards, BVG

[jeffreybrown]

=IF(TEXT(A6,"ddd")="Sat",2,IF(TEXT(A6,"ddd")="Sun",0,1))

[Badvgood]

=IF(TEXT(A6,"ddd")="Sat",2,IF(TEXT(A6,"ddd")="Sun",0,1))

Thank you very much. I can now deconstruct it to make it suitable for my exact purpose.

Kind regards and stay safe.

BVG

[jeffreybrown]

You are very welcome BVG and thanks for the feedback.

[Badvgood]

You are very welcome BVG and thanks for the feedback.

Sorry to be a pain but I have noticed an error in what I was requesting, well rather I did not consider the possibility of how it would handle cells that did not contain a date.

As I copy the formula down, when it gets to a cell that is sometimes populated with a date and sometimes it is not, I get the result of 1, which of course is for a weekday.

I need it to return blank zero nothing.

Thanks again,

BVG

[jeffreybrown]

How about

=IF(N(A6),IF(TEXT(A6,"ddd")="Sat",2,IF(TEXT(A6,"ddd")="Sun",0,1)),"")

[Pepe Le Mokko]

Administrative Note:

Please don't quote entire posts unnecessarily. They clutter threads and make them hard to read.
Use the "Quick reply" instead
Thanks