Formula to know if a "day" (e.g. Thursday) falls between certain days ?

[Alex Kriman]

Hi,
Need to know if a "worked" day is between the days a worker is supposed to work throughout the week ?

for example:
John is supposed to work Tuesday-Saturday....so, does Thursday fall between Tuesday & Saturday (yes, no) ?

A1=Thursday

B2=Tuesday

C2=Saturday

[#2]

Alex,

Thursday			4	Yes		Monday
	Tuesday	Saturday	2			Tuesday
			6			Wednesday
						Thursday
						Friday
						Saturday
						Sunday

D1:D3

=MATCH(A1,$G$1:$G$7,0)
=MATCH(B2,$G$1:$G$7,0)
=MATCH(C2,$G$1:$G$7,0)

E1

=IF(MEDIAN(D1:D3)=D1,"Yes","No")