Auto populate dates of a month based on dropdown selection

Hello, I am sure there is an easy solution to this, but I am drawing a blank. I want a row of cells to auto populate with dates of a month based on a drop down box I have of selected months & years. So, in A1, I have a dropdown box that a user can select a month/year (like August 2012). From that selection, I want cells A3 to Axx (A33 for months with 31 days) to auto populate with the dates for that month and only the dates for that month. In A1, I created a "select from dropdown" that is linked a named range in a separate tab. Any suggestions?

Put this in A3:

=IF(A1="","",DATEVALUE("1 "&A1))

Format that cell as date in the style that you prefer. Then put this formula in A4:

=IF(A3="","",IF(MONTH(A3)<>MONTH(A3+1),"",A3+1))

Then copy this down to A33 (although earlier in your post you talked about having a row of cells, so you might want to put the formula in B3 and then copy across).

Hope this helps.

Pete

Worked perfect, Thanks!