vba - Excel - Day and Date of Month

I have tried a few "Date" formulas but I cannot get this to work.

Here is my issue:

I want to set up a spreadsheet that will allow the user to type in A1 - the month and year.

I would like my spreadsheet to automatically populate Column A with "Days" of the month e.g. if the month begins on Wed, then Wednesday will be the first day. I would then like column B to populate dates e.g. 01/12/2018 (UK format).

Also, I would like Sunday to be omitted.
I have a manual version of this where I must type in the values each month but I would like to automate it as this is required to be done 80 times and I don't want to have to firstly populate manually, then copy and paste 79 times.

Any suggestions?