count how many employees were termed in less than 90 days per Month

Hello,

I am trying to get a count of how many were termed in less than 90 and more than 90 days per month.

In Column A I have their hire date, In Column B I have their Termed Date (If they have been termed), In Column C I have their number of days worked.
I need a formula that tells me in "March" I had ? that were termed in less than 90 days and ? total number termed in total for each month.

I tried to attach a sample table but was unable to.

Thanks for any help
Granny

Withdrawn by FR

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Probably the easiest way tio do this would be to add a helper column and calc the days before Term, then use COUNTIF(helper-column,"<=90") then just change the <=90 bit

Edited grid below needed clarification.

Try this.

I changed the month headers to actual dates (first of the month works). It simplifies the formulas.

Row\Col	E	F	G	H	I	J	K
2	Mar	Apr	May	Jun	Jul	Aug
3	3	6	0	0	0	0	In E3 filled across =SUMPRODUCT(--(MONTH($B$2:$B$19)=MONTH(E$2)))
4	2	2	0	0	0	0	In E4 filled across =SUMPRODUCT(--(MONTH($B$2:$B$19)=MONTH(E$2)),--($C$2:$C$19<=90))

You're welcome. Thank you for the feedback.