Oooh, sorry Marvin, I have to take it back.In column B, your solution marks only April and November for 2007, but all the months in between have to be marked too. You have to do some date arithmetic for this problem because of the need to analyze the span for each pair of start and end dates.
Bookmarks