Adding data based on a date or date range

Question

Hello,&nbsp;I am trying to add employees based on the date they are hired.&nbsp;I think the countif formula is what I need.&nbsp;&nbsp;Can anyone help me?

wyn hopkins · Answer

&nbsp;Hi ladysoulrbc&nbsp;&nbsp;As long as you have proper dates entered into cells then COUNTIFS will work for you.&nbsp;Typing April 17th&nbsp; for example will not allow this to work.&nbsp;The formula in column G2 of the attached image is this&nbsp;=COUNTIFS(&nbsp;&nbsp; A1:A4,"&gt;="&amp;D2,&nbsp;&nbsp; A1:A4,"&lt;="&amp;E2&nbsp;&nbsp; )&nbsp;Which counts the&nbsp;date if it is greater than or equal to the date in D2&nbsp;&nbsp; AND&nbsp;&nbsp; is less than or equal to the date in E2&nbsp;&nbsp;

Forum Discussion

Adding data based on a date or date range

Share

Resources