Check to see if student attended class on certain date
Posted on 2014-03-01
I run a fitness bootcamp and am trying to send out docs that show how many classes a member has attended. I have an Excel spreadsheet with two sheets:
1. showing the calendar. Each cell contains that date.
2. a sheet showing student name (col.a) and attendance date (col. b)
I have drop down box that will select a student. I'd like to then use a conditional formatting to color all dates of attendance by looking for the student's name, then pulling an array of all the attendance dates..then checking for the date.
Can someone help me with that formula, please?