Scott,

Your test spreadsheet had the course/event and date columns swapped
from what you had in your original message. In your message above, the
layout showed the course name left of the date, so I assumed they were
in cols A and B respectively, although your formulas may have indicated
otherwise - I didn't examine them carefully. I am sending back your
spreadsheet corrected.

Declan