MY FORMULA:
=SUMIFS($AD$2:$AD$20000,$D$2:$D$20000,">="&$AK$3,$D$2:$D$20000,"<="&$AL$3,$K$2l$K$20000,9902)

AK3 IS 1-1-13 AL3 IS 1-30-13

I get a return of 0.

How important is the formatting of the cells with dates in them for this formula to recognize the dates?


Thanks