calculating number of weeks in a month ( jan -Dec 13) starting every monday+display

Hi ,
I have spent days to figure out how do I calculate the week numbers. Well this is possible .
But is there any way, where it does the following:
1. Calculates current month weeks ( week starting on Monday)
2. Displays them in a column with their numbers and Month
3. Highlights the current week

Is it possible?

Regards

Place the Year (i.e. 2013 ) in "A1", Run code, Month names shown in column "A", "Monday" Dates shown in column "B".
If this is not exactly what you want, please show an example of your expected reaults.

Please Login or Register  to view this content.

Regards Mick

Hi,
This works fine . This is what I wanted.
Thanks again for your help
Regards

Your welcome
Regrds Mick