Take user input start date and end date. Create a column for each month between these

[TheCyrusVirus]

Ok, So I have a worksheet where the user inputs a start date in cell a2 and an end date in cell b2

I need to work out the months this covers. So for example 01/01/2010 - 31/12/2010 and then put a column heading in for each month starting in B4 and going across that row for however many columns i need.

So in this case I would have Jan-2010 in B4, Feb-2010 in C4 and so on up until Dec 2010 in the last column.

Can anyone give me pointers on how to do this in VBA. I also need to be able to use the calculated months in sql queries so it would be good if I could have another row below the headings with the date range in date format So b4 would be Jan-2010. b5 would be 01/01/2010 - 31/01/2010.

Any help would be greatly appreciated

Thanks