Book1.xlsx
1111256454.jpg

I'm looking for a formula that can give me the count of leave per month in column F considering the leave start durations in column B and leave end in column C

the formula should ignore the blank cell as well the cells that ara contains text or anything else apart from date format

I hope I can find the solution to this inquiry.

I have already attached the template for your reference.