Joining two IF/ AND statements

[Anthea]

I am trying to join two statements but keep getting errors. Please could someone help me and explain how to join them into one statement? Both Statements work correctly on their own

=IF(AND(A12>=$K$3,A12<=$L$3),"Sunday",(TEXT(A12,"dddd")))
=IF(AND(A12>=$K$4,A12<=$L$4),"Sunday",(TEXT(A12,"dddd")))

[TABLE="width: 450"]
<tbody>[TR]
[TD]ROW/ COLUMN[/TD]
[TD]Column A[/TD]
[TD]Column K[/TD]
[TD]Column L[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD="colspan: 2"]LEAVE[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]START[/TD]
[TD]END[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD="align: right"]2018/03/05[/TD]
[TD="align: right"]2018/03/24[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD="align: right"]2018/12/16[/TD]
[TD="align: right"]2019/01/02[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]12[/TD]
[TD]Thu 2018/03/01[/TD]
[TD]Thursday[/TD]
[TD]Thursday[/TD]
[/TR]
[TR]
[TD="align: right"]13[/TD]
[TD]Fri 2018/03/02[/TD]
[TD]Friday[/TD]
[TD]Friday[/TD]
[/TR]
[TR]
[TD="align: right"]14[/TD]
[TD]Sat 2018/03/03[/TD]
[TD]Saturday[/TD]
[TD]Saturday[/TD]
[/TR]
[TR]
[TD="align: right"]15[/TD]
[TD]Sun 2018/03/04[/TD]
[TD]Sunday[/TD]
[TD]Sunday[/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[TD]Mon 2018/03/05[/TD]
[TD]Sunday[/TD]
[TD]Monday[/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[TD]Tue 2018/03/06[/TD]
[TD]Sunday[/TD]
[TD]Tuesday[/TD]
[/TR]
[TR]
[TD="align: right"]18[/TD]
[TD]Wed 2018/03/07[/TD]
[TD]Sunday[/TD]
[TD]Wednesday[/TD]
[/TR]
[TR]
[TD="align: right"]19[/TD]
[TD]Thu 2018/03/08[/TD]
[TD]Sunday[/TD]
[TD]Thursday[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD]Fri 2018/03/09[/TD]
[TD]Sunday[/TD]
[TD]Friday[/TD]
[/TR]
[TR]
[TD="align: right"]21[/TD]
[TD]Sat 2018/03/10[/TD]
[TD]Sunday[/TD]
[TD]Saturday[/TD]
[/TR]
</tbody>[/TABLE]

 

[steve the fish]

Are they meant to be an OR or an AND.

 

[steve the fish]

OR would be this for example:

=IF(OR(AND(A12>=$K$3,A12<=$L$3),AND(A12>=$K$4,A12<=$L$4)),"Sunday",(TEXT(A12,"dddd")))

 

[Anthea]

Thank you so much ... that is exactly what I was looking for. I tried the 'or' instead of the 'and' but never thought to put them together

 

[Anthea]

To include all the cells K3 to L11 would I just expand the references for Column K from K3 to K11 and the same for Column L or is there a more elegant way of referencing those cells?