however I would also like to look to see if another criteria is met. For
instance, the month falls between a range of begin date and end date.


It sounds like you need to look into the AND function rather than OR.

AR