Not quite what I am looking for, thank you though. I want it to return First, Second, or Third in one cell. Also, I think the dates should be something like,
(exam on 1/4/07)
1/4/07 to 6/31/07 - return first
7/1/07 to 1/31/09 - return second
2/1/09 to 1/31/10 - return third