=SUMPRODUCT(--(YEAR(D3:D58)=1977))
Regards,
Stefi

€žandy€� ezt Ã*rta:

I am working on a seniority list and want excel to list the number of people
hired in each specific year. What is the formula I would use to just extract
that year of hire information? Sheet 1 lists all the seniority dates and
sheet 2 shows all the statistics so i have to refer to sheet 1 in the
formula. I was trying to use =countif(senioritylist!d3:d58,"="(year)1977)
and so on for consecutive years, but that is not working.
--
andy