Mark cell if location matches and date falls between date range

I'm trying to create a formula that will match a location number between two sheets within the workbook, then look at a service date and mark an X in the appropriate column to tell if the event date takes place 30, 60 or 90 days prior an event date.
Example attached.