Help! Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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