Month Search in two dates

[amitlonkar]

Please help to find out particular month in two dates..
examples there is two dates in A2 and B2 column - 01/01/2017 in A2 column and 05/31/2017 in B2 column and i want to check if Particular month is falling in date or not... if i want to find out April 2017 month in both dates so what is a formula for this.. Please suggest

 

[admiral100]

Hi,

Try this :

C2 = April 2017
D2 =IF(AND(MONTH(C2>=MONTH(A2)),MONTH(C2<=MONTH(B2))),"Between","Not found")

 

[amitlonkar]

Hi Admiral..
heeeyyyyy ....its working dude... thank you so much.....