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")))
<tbody>
</tbody>
=IF(AND(A12>=$K$3,A12<=$L$3),"Sunday",(TEXT(A12,"dddd")))
=IF(AND(A12>=$K$4,A12<=$L$4),"Sunday",(TEXT(A12,"dddd")))
ROW/ COLUMN | Column A | Column K | Column L |
1 | LEAVE | ||
2 | START | END | |
3 | 2018/03/05 | 2018/03/24 | |
4 | 2018/12/16 | 2019/01/02 | |
5 | |||
6 | |||
7 | |||
8 | |||
9 | |||
10 | |||
11 | |||
12 | Thu 2018/03/01 | Thursday | Thursday |
13 | Fri 2018/03/02 | Friday | Friday |
14 | Sat 2018/03/03 | Saturday | Saturday |
15 | Sun 2018/03/04 | Sunday | Sunday |
16 | Mon 2018/03/05 | Sunday | Monday |
17 | Tue 2018/03/06 | Sunday | Tuesday |
18 | Wed 2018/03/07 | Sunday | Wednesday |
19 | Thu 2018/03/08 | Sunday | Thursday |
20 | Fri 2018/03/09 | Sunday | Friday |
21 | Sat 2018/03/10 | Sunday | Saturday |
<tbody>
</tbody>
Last edited: