Cell to return month

[Oliver2014]

Help...!!!!!

I'm needing a formula which will paste text into a cell if another cell is between two set dates.

For or example if A1 is between 2/4/15 and 12/5/15 A2 to show April
if A1 is between 13/5/15 and 10/6/15 I'd need A2 to show May... And so on.

I'd love to be to just format the cell to custom but as the dates are based on number of month I can't.

Any ideas??????

 

[pbornemeier]

With the example: if A1 is between 2/4/15 and 12/5/15 A2 to show April
Why should it show April instead of May?

What rules determines the boundary between months?
2/4/15 is 3rd Wednesday, 12/5/15 is 2nd Tuesday
13/5/15 is 2nd Wednesday, 10/6/15 is 2nd Tuesday
I do not see a pattern.

 

[Oliver2014]

With the example: if A1 is between 2/4/15 and 12/5/15 A2 to show April
Why should it show April instead of May?

What rules determines the boundary between months?
2/4/15 is 3rd Wednesday, 12/5/15 is 2nd Tuesday
13/5/15 is 2nd Wednesday, 10/6/15 is 2nd Tuesday
I do not see a pattern.

These dates are just random dates, the actual dates are in blocks of either 4 or 5 weeks.

Would the pattern help with the formula??

 

[pbornemeier]

If the pattern is consistent from year to year then a formula could be developed.