Auto fill week days based on month chosen

Hi,
I want my spreadsheet to auto fill my weekdays down the row based on the month and year chosen.
Can someone help me???

It worked beautifullly! It was just what I was looking for.
Thank you so much!

-MT

Boon,
I want to thank you for helping me with my spreadsheet. The macro you gave me worked, however, when I chose one month then chose a month after that (with less days), it leaves the excess days from the previous month in the cells at the bottom. For example: I chose January 2013 then I changed it to March 2013... in my row it shows .....March 28. March 29. January 30. January 31.... How do i make it not show that without asking a user to reset the form each time?

hmm... that didn't do it. I'm new to macros. I used this new code in place of the first code you gave me. is that right? When i did that it performs exactly like the first code you gave me. Is there a way i can attach the updated spreadsheet so you can see it? I appreciate all that you have already helped me with. You really did help me tremendously!!!! I just dont want the user of this form to get confused as to why the months at the bottom show differently.
Thank you Boon!

-MT

figured out how to attach it. Here it is!

Thank you,

MT

That worked! good deal! thank you again so much Boon!

-MT