Counting by months

[gncntry96]

I'm trying to calculate the number of terminated employees in any given month, so I'm comparing the termination date of each employee to a list of months of the year. I also need to account for the fact that employees are in one of two companies. I think I need a COUNTIFS formula:

=countifs(C2:C233,"company x",G2:G233,???????)

The cell with the month I want to compare to is I237. G2:G233 is the termintation dates for the employees.

This forum has been so great...I'm hoping some more of you gurus can help with this one.

thanks in advance.

 

[barry houdini]

If you have a date in I237 try this

=COUNTIFS(C2:C233,"company x",G2:G233,">"&EOMONTH(I237,-1),G2:G233,"<="&EOMONTH(I237,0))

 

[gncntry96]

That's perfect! Thanks so much!
Rachel