Pulling values of specific cells based on corresponding dates?

Hi,

I am trying to organize, on a separate sheet, all of my contracts that end within specific months. I am trying to use the numeric values that Excel assigns to specific dates within a range, but I'm not sure how to build the formula to pull the values from Sheet 1, column C based on the range. I am trying to compile this for each month of 2012 onto sheet 2.

See attached with the numeric values, but it's not working.
/RWL