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:
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.