Headcount by month when end date is blank or employee only worked a few days in a month

Dear all

Hello - thanks for this forum - it seems really helpful! I am trying to calculate headcount per month and i tried two different formulas:

- =--IF(AND($B2-DAY($B2)+1<=D$1,$C2-DAY($C2)+1>=D$1),1,0)
- =($B11<=H$1) * (($C11>=H$1) + ($C11=""))

however the first one works well but it only works when there is an end date. If the end date is blank (current employee)
the second solution works but if the person only worked a few days in the month, they appear as 0 headcount

i guess my two issues are:
- when an employee has only worked a few days in a month (which is solved by the above)
- when the end date is blank

Does anyone have a solution for this problem? Much appreciated

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

many thanks. I attach the document