VBA Code to auto date cells

[data808]

I have a merged C2 and D2 cell where I will type in the month "January" for example and another cell G2 that I will type in the year 2022. I will do this for every month. Is there a way based on which month and year I type into these cells, to auto populate 1/1/22 - 1/31/22 from cells A4 - A34? I realize that not every month has 31 days and so if these happens for February for example and goes to 2/31/22, that is ok. I am just trying to create a template and we will only be using the dates that we need to and ignore the dates and don't exist. Thanks.

 

[data808]

The marked solution has been switched accordingly.

@data808 - in your future questions, please mark the post as the solution that answered your question to help future readers. No further action is required in this thread.

Apologies. Wanted to add in that comment I made about the line [G4:G34] = [INDEX(UPPER(G4:G34),)] and how I had to change the event for it work properly. That's why I chose #58 post to be the solution. Thanks for the help though.