Show the Month details in row wise based on the Date Duration

Hi All,

A quick help required on the below inputs.

I have few employee list as Input details , which talks about the for a particular duration an employee is tagged to which project and customer.

Now I want to derive the 1st of every month between the duration provided of each employee and the month details to be shown as row wise.

I have attached the sample data in the attached worksheet. It has two sheets called “ Input” and required output in “Output” sheet. Can this be achieve through macro ?

Please help

Regards,
Kamal M.