I've been knocking this about all day, and am coming up short.

In brief, lets say I have the following:

Column A has an employee name.
Column B has their original hire date. (i.e. 11/12/2007)
Column C has their termination date. (i.e. 09/14/2014)

I am trying to separate an enormous spreadsheet into one which shows all employees who were employed during 2011, 2012, 2013 and 2014. In the example above (11/12/2007 through 9/14/14) that person should show up on queries for 2011, 2012, 2013, and 2014.

I am looking to find a way to create a formula which would look at the range of dates between Column B and C, and set a variable that says only return row if 2011 is included in that range. There are all sorts of reasons my various attempts haven't worked, but I'm nagged with the feeling that this should be easier than I'm making it.

Any assistance would be invaluable!