Search turned up nada on this:

How do I write a countif statement that says to include the line in the
count if the date on that line is between 10/01/05 and 12/31/05?

I’ve even tried a couple:

=IF(AND(F5:F98>9/30/2005,F5:F98<1/1/2006),COUNTA(F5:F98),"")
=IF(AND(F5:F98>9/30/2005,F5:F98<1/1/2006),COUNT(F5:F98),"")

Do I have bad syntax, bad logic, bad formula use? Do dates have to be
written out differently?


Thanks to anyone who takes the time to respond.

Sam