dropdownlists: month & year to autofill weekdays in a column

Hi all,

I'm fairly new to VBA and would appreciate any help you can provide with the following problem. I am trying to make a spreadsheet that records the number of hours I've worked each month.

I have two drop down lists: one containing months (in the format "January", "February"...) the other containing years ("2011", "2012"...).

When I select any combination I want Excel to autofill a column with the weekdays of that month in the format dd/mm/yyyy.

I'm not sure where to begin, but I have recorded a macro by manually filling in the first date of the month and using the autofill feature down the column; I just don't know where to go from here...

Cheers,
Jim