INDEX MATCH that compares if date is between two dates and returns yes or no

I'm trying to create a spreadsheet to eliminate hours of manual data entry, but I'm very new to using INDEX and MATCH. I'm trying to make it so the Jan-Mar sheet looks through the data dump sheet for employee names and the date a task was completed, then if the date falls between two dates on the date ranges sheet, return a yes or no on the corresponding week on the Jan-Mar tab.

I've been scouring forums for hours now and can't quite get it right.