Calendar Month and Year lists to Autofill Dates

I apologize in advance that I did not search this forum for my answer. I have been searching google for quite some days now and either they are not explaining it to me in enough laymen or its just not the right situation because of my cell structure. Also im new to this forum so please if my post is in the wrong forum I wont be offended if it is moved.

I am making a schedule calendar template for my work and my main goal right now is I have two lists on a separate worksheet for the month and the year. The dates of the calendar are all on their own rows above the calendar blocks. The top row is the days of the week. I want to know how I can have the month and year selected from the drop down lists and automatically fill in the proper dates with the days of the week.

I have attached the file in question.

Hello
If you just need to display the Days across row 2 then you could use the DATEVALUE Function. See my attachment. Note that I'm using th UK format 'dd/mm/yyyy'. You might have to amend the functions. Just as an idea, you could also Conditionally Format the cells for the 29 - 31 of each month to be greyed out if 'Not Applicable' to the Month/Year selected.

Hope this helps.
DBY