Can I do a count function by date?

For instance, I have a spreadsheet that includes all employees in my
company, and their hire date. I would like to somehow be able to count all
employees hired this year, and do so by using this column of "hire date"
which is in the format of 02/01/2005.

Thanks

if your hire date is in column A, this would work:
=COUNTIF(A:A,"1/1/05")

"jbressma" wrote:

Can I do a count function by date?

For instance, I have a spreadsheet that includes all employees in my
company, and their hire date. I would like to somehow be able to count all
employees hired this year, and do so by using this column of "hire date"
which is in the format of 02/01/2005.

Thanks

one way:

=SUMPRODUCT(--(YEAR(A1:A1000)=2005))

alternatively:

=COUNTIF(A:A,"=1/1/2005")

or, if you use this after this year,

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


In article ,
"jbressma" wrote:

Can I do a count function by date?

For instance, I have a spreadsheet that includes all employees in my
company, and their hire date. I would like to somehow be able to count all
employees hired this year, and do so by using this column of "hire date"
which is in the format of 02/01/2005.

Thanks

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")