How to Calculate the first and last date of a Month Using VBA Code when the Month and Year is Pulled from Cells in Excel

Hello All:

I am trying to figure out How to Calculate the first and last date of a Month Using VBA Code when the Month and Year is Pulled from Cells in Excel. An additional intrigue is I need the resulting calculation to look like so:

1+yy+mm+dd

For Example May 2020:

first date = 1200501, as Text

last date = 1200531, , as Text

Of Course, I hope VBA is smart enough to handle leap years.

Sample VBA code would be much appreciated.

Many Thanks