List out the staff on leave on any one particular date according to sequence of entries

Hi everyone,

Can someone please help.

I have a database that I keep to track my staff going on leave, the fields include the sequence of the entry (who applied first who applied second etc), staff name, start date and end date. they are column A, B, C, D respectively in the INPUT tab of the sample file.

what i need is to show is in a dynamic sheet, list out all the staff who is way on any particular date of the month according to the sequence of the entries.

the solution i found so far have problem once the date ranges overlap.

Any help is greatly appreciated.