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

[MickG]

Hi, Try this:-
Remove the "Chr(10) & one "Ampersand" sign if you don't want the Dates Wrapped.

Please Login or Register  to view this content.

Regards Mick

[TheCyrusVirus]

Thanks Mick

Works like a charm. I always fall over when working with dates in Excel.

Much appreciated.

[TheCyrusVirus]

How do I mark this as solved?

[abousetta]

Go to the first post in the thread and click on EDIT --> ADVANCED and at the top next to your TITLE there will be a dropdown menu with one the options being [SOLVED].

Good luck

abousetta

[TheCyrusVirus]

Thanks very much