I have the attached the book I am having trouble with.

I'd like to have Sheet 2 return a report of anyone (first and last names) that have X's in a given period on a certain day. So for example on Friday, June 28th I'd like to return anyone that has an X from the previous day (Thursday June 27th) Periods 4,5,6 and the current date periods 1,2,3. I will be running this "report" everyday with the previous date periods 4,5,6 and current day's 1,2,3 so would like to be able to manipulate the date.

Thanks for any help anyone can offer!