Okay, but if you want to select the dates (in Column C) the cells in this coloumn do NOT contain date values but text like MARCH 2014 APRIL 2014 etc.
But a selection in ListBox2 if you have two but only want one then what?