Formula to Identify Out Of Hours

Good afternoon,

I need to design a formula that will tell me if some inbound calls that come into my call centre are within working hours

I have created a formula

=IF(AND(Y2>=8,Y2<=20),"0", "1")

that will tell me between to static times weather its inside or outside of normal office hours giving it a value of 0 or 1.

In column AA i have the day of the week and want to add this into the formula, so i now want to say if basically if its Saturday

=IF(AND(Y2>=8,Y2<=13),"0", "1")

but if any other day than

=IF(AND(Y2>=8,Y2<=20),"0", "1")

Thanks in advance

DJ

Thank you very much. A quick question is it easy to add if Sunday than 1 as Sunday will always be out of hours?

Thank you, much appreciated.