Return results based on days of the week

[jeffdlinn]

I have the following data in Column A. I'm trying to write a formula that looks at column A and will place the value of 1 in column b if the day of the week is not Tuesday or Wednesday.

so
Saturday, January 1, 2022 = 1
Sunday, January 2, 2022 = 1
Monday, January 3, 2022 = 1
Tuesday, January 4, 2022 = 0
Wednesday, January 5, 2022 = 0

Saturday, January 1, 2022

Sunday, January 2, 2022

Monday, January 3, 2022

Tuesday, January 4, 2022

Wednesday, January 5, 2022

Thursday, January 6, 2022

Friday, January 7, 2022

Saturday, January 8, 2022

Sunday, January 9, 2022

Monday, January 10, 2022

Tuesday, January 11, 2022

Wednesday, January 12, 2022

Thursday, January 13, 2022

 

[alansidman]

=IF(AND(WEEKDAY(A1)<>3,WEEKDAY(A1)<>4),1,0) and copy down

Book11
	A	B
1	Saturday, January 1, 2022	1
2	Sunday, January 2, 2022	1
3	Monday, January 3, 2022	1
4	Tuesday, January 4, 2022	0
5	Wednesday, January 5, 2022	0
6	Thursday, January 6, 2022	1
7	Friday, January 7, 2022	1
8	Saturday, January 8, 2022	1
9	Sunday, January 9, 2022	1
10	Monday, January 10, 2022	1
11	Tuesday, January 11, 2022	0
12	Wednesday, January 12, 2022	0
13	Thursday, January 13, 2022	1
Sheet2

Cell Formulas
Range	Formula
B1:B13	B1	=IF(AND(WEEKDAY(A1)<>3,WEEKDAY(A1)<>4),1,0)

 

[jeffdlinn]

Thanks - Worked great

 

[Fluff]

Bit late, but another option

=--(A1=WORKDAY.INTL(A1-1,1,"0110000"))