Hello everyone,

Just trying to get a Countifs to work for a table on income using dates.

I have the formula working for SUMIFS, and I thought all it would require is to paste formula and change SUMIFS to COUNTIFS, but apparently it's never that easy. Below is the formula as it stands now:

=COUNTIFS('Income'!$D:$D,'Income'!$A:$A,">="&DATE(2012,1,1),'Income'!$A:$A,"<"&DATE(2013,1,1))

Can anyone tell me what I'm getting wrong with this? Thank you