Hi

I am not to good with formulas, but did you try something like

SUMPRODUCT(isnumeric('FY 2006'!A8:A550="12-26-05")*('FY 2006'!A8:A550<="1-1-06")*('FY 2006'!B8:B550))

Thanks
Denis