Counting dates within a range

[mhitomi_7]

I'm trying to use countifs to count dates that fall within a range >= and <=.

It doesn't seem to recognize the <= statement....what am I missing?

=COUNTIFS('MW Project Tracker'!AF:AF,">=2/1/13")+COUNTIFS('MW Project Tracker'!AF:AF,"<=2/28/13")

Plz help

Thanks

MIke

[Lemice]

Hello,

You are adding two COUNTIFS together while in fact you can do it with just one ...
Try this instead

Please Login or Register  to view this content.

[Tony Valko]

Use cells to hold the date criteria:

A1 = 2/1/13
B1 = 2/28/13

=COUNTIFS('MW Project Tracker'!AF:AF,">="&A1,'MW Project Tracker'!AF:AF,"<="&B1)