Formula to extract Employee work schedule report from "date of hiring list"

Hi guys,

I have a small requirement that I need to complete. I attached the sample data file.

I have a data sheet with employee hiring schedule. There are 8 employees and dates when they are hired by the company. Each employee is hired till the date it says that service stopped (thats when all the employees hired till that date are withdrawn from service).

I need to prepare a report as to how many employees are hired on all Mondays from 30th of March till 30th of July and the list of names. (I inserted the layout of the report in the attachment).

I tried doing a vlookup (TRUE) for the dates. But that didn't work out well. I think we can achieve this using VBA programming.

Please help me with this report.

Thank in advance,
Ravi.