Should have been

=COUNTIF(A:A,"=1/1/2005") - COUNTIF(A:A,"12/31/2005")

In article ,
JE McGimpsey wrote:

=COUNTIF(A:A,"=1/1/2005") - COUNTIF(A:A,"=12/31/2005")