COUNTIF / SUMIF / DATES formula

[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,

 

[Fluff]

Duplicate to: First Time Poster!

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.