I have dates in column A that are mm/dd/yyyy. I need to now convert the date from column A into yyyy;mm;dd for the DATE function. Below is what I have to get the data I want. Currently it is hard coded. I need the 2011;12;30 to be sucked in from A2 which is 12/30/2011. Then I need to add one more day to it for the second date (2011;12;31). Any ideas?
=COUNT(FILTER( 'Sheet 1'!O:O ; 'Sheet 1'!O:O >=DATE( 2011;12;30) ; 'Sheet 1'!O:O <=DATE( 2011;12;31) ; SEARCH( "b" ; 'Sheet 1'!I:I ) ) )