First Time Poster!

[Amy Lloyd]

Hi,

I am new to the site but hoping someone can help with ease...

I have a tab in a workbook that includes a list of dates when a companys vacancies were given approval - column E. I have another column that provides for the date when the vacancy was filled - column O.

I am looking to create a table in a new tab with each month of the year spanning across columns F:Q and want to use the data in the first tab to calculate how many vacancies were open and closed in each month in the summary table. See image attached, ignore the numbers already in the table - these are a result of failed COUNTIF formulas.

Any advice would be appreciated.

Thanks,

 

[ExceLoki]

from you description i believe this will work for your needs. let me know if there is anything missing or still needed
----------------------
data

Book1
	E	F	G	H	I	J	K	L	M	N	O
1	date approval obtained	live vacancy date	CV's cource	replaced employee	candidate name	internal/ direct/ agency	hiring manager	department	SMF/ certified	contract type	offer?
2	1/15/2021										2/10/2021
3	1/18/2021										3/5/2021
4	2/15/2021										4/1/2021
5	2/18/2021										4/5/2021
6	2/20/2021
7	3/15/2021
Sheet1

-------------------------
result

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Status	1/1/21	2/1/21	3/1/21	4/1/21	5/1/21	6/1/21	7/1/21	8/1/21	9/1/21	10/1/21	11/1/21	12/1/21	1/1/22	2/1/22	3/1/22	4/1/22
2	Open	2	3	1	0	0	0	0	0	0	0	0	0	0	0	0	0
3	Closed
4	Filled	0	1	1	2	0	0	0	0	0	0	0	0	0	0	0	0
5	On Hold
6	Total
Sheet2

Cell Formulas
Range	Formula
B2:Q2	B2	=COUNTIFS(Table2[date approval obtained],">="&B1,Table2[date approval obtained],"<"&C1)
B4:Q4	B4	=COUNTIFS(Table2[offer?],">="&B1,Table2[offer?],"<"&C1)