Adding data based on a date or date range

[ladysoulrbc]

Hello,

I am trying to add employees based on the date they are hired.

I think the countif formula is what I need. 

Can anyone help me?

[#2]

 Hi @ladysoulrbc

As long as you have proper dates entered into cells then COUNTIFS will work for you.

Typing April 17th  for example will not allow this to work.

The formula in column G2 of the attached image is this

=COUNTIFS(   A1:A4,">="&D2,   A1:A4,"<="&E2   )

Which counts the date if it is greater than or equal to the date in D2   AND   is less than or equal to the date in E2