1-Feb PUBLIC HOLIDAY
10-Feb SATURDAY
15-Feb SUNDAY
20-Feb SATURDAY
21-Feb SATURDAY
22-Feb SUNDAY
23-Feb SATURDAY
24-Feb SUNDAY
25-Feb 7:30 - 4:30 PM
26-Feb SUNDAY
27-Feb SATURDAY
From these data, i use this formula '=INDEX(A1:A11,MATCH("SATURDAY",B1:B11,0))
and the result shown...