month between two months

[dvb_24]

Hi all, I'm trying to get TRUE if one month is between other two months, for example. First row (beggining of period) 12, Second row (end of period) 5, third row (number I want to evaluate). Does anybody know a simple formula to sort this out?

[zbor]

can you upload an example with some possible inputs and outputs?

[daddylonglegs]

So what numbers would be TRUE? Is it 12, 1, 2, 3, 4 and 5?

With start month in A2, end month in B2, month to evaluate in C2, use this formula in D2

=(C2>=A2)+(C2<=B2)+(A2>B2)=2

[dvb_24]

I've highlighted what my aim is...

[daddylonglegs]

Does my suggested formula work for you? Adapted to your setup it would be this formula in H4 copied across

=(H3>=H1)+(H3<=H2)+(H1>H2)=2

[dvb_24]

It worked! thanks very much could you please rbriefly explain what it means? why=2?

[dvb_24]

thanks it worked!

Does my suggested formula work for you? Adapted to your setup it would be this formula in H4 copied across

=(H3>=H1)+(H3<=H2)+(H1>H2)=2