Count days falling within given period (with criteria)(absence tracker)

Hi everyone,

Searched this forum and couldn't find a solution.
I am trying to create an absence tracker.

Have several types of absence.
Have multiple periods.
Have multiple employees.

What formula would you suggest here.

I have:

=COUNTIFS($G$3:$G$9,">="&$C$2,$H$3:$H$9,"<="&EOMONTH($C$2,0),$F$3:$F$9,$C$4,$I$3:$I$9,C3)

What I am trying to achieve is:
criteria:

1. Search absence period: dynamic (drop down)
2. Search absence type: dynamic (drop down)
3. Search employee: dynamic (drop down)

records of absence:

always between dates

outcome:

count number of days of absence
if absence starts on or after given month start date, and
if absence ends on or before given month end date

if absence belongs to employee X
if absence is of type X

further outcome:

if there are absences which started before given month and ended before month end or after month end
then count them as well.

workbook attached.
Hope you can guide me thank youCapture1.PNG