Locate a date within a date range from another sheet

[kserr001]

I have 2 sheets in my workbook.
1. "not available" is a list of people and week ranges. there are is an 'x' placed in the week range that the person is unavailable.
2. "holidays" same list of people and dates of holidays/conferences/meetings in the year.

What I'm trying to do is 2-fold:
1. locate a "holiday" date within the date range in the "not available" sheet, THEN
2. if there is an 'x' for a person (e.g. JOE) during a date range (6/28/2014-7/4/2014), and a holiday date (7/4/2014) falls within that range, an 'x' also appears for Joe in the holiday sheet for that date..

I hope that makes sense. I've attached "schedule sample".

(I've tried to do just start dates, rather than a week range, which worked for a single date. But if there are multiple holidays/conferences/meetings that could spread across multiple date ranges, I get a #value!)

[p24leclerc]

In your "Not available" sheet, you only need the first day of the week in each column. The next column is a week later so it the previous cell plus 7 days.
With your table set up this way it is easier to calculate if someone is available at a specific date.
See attached workbook and formulas.
Regards

[kserr001]

Thank you!! It worked!!
Now I'm running in to a #n/a error message when I move in to holidays/meetings that fall in 2015.

[p24leclerc]

make sure your last column in the "Not Available" table has a date far enough so you don't get this message. Instead of an X in this column you can put a special character or a word to warn you that it falls off you current date table.

[kserr001]

I figure it out! The year dates on my Holidays were incorrect.

Thank you so much p24leclerc!!!