(Sorry for the poor title.. not sure how to describe this very well :P)
I want to be able to determine "Attendance Status" (Column B) based on if someone has attended within the last 4 (may want to change over time) weeks. So on the attached Sample Book, if anyone attended Aug-11 or later would have Y for "Attending".
Sample Book.xlsx
Bookmarks