Forum Discussion

Alex Kriman's avatar
Alex Kriman
Copper Contributor
Dec 04, 2017

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

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

excel

1 Reply

Sort By
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Dec 04, 2017

    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")

Resources