Displaying the Weeks in a Selected Month

quite a lot of formulas used here
to calculate the 1st of month
to calculate the first friday
then the same formula adding 3 or 7
to calculate if in 5th week
and the last day of month if in 5th week
and calculate the days

i have changed a few things
1) the year and month dropdown - I have setup as actual dates
so you need to enter as a date format for both and then formatted to display Year and Month ~(we could probably change to use text and convert to a date if required) - just first wanted to setout and see if that works for you

then used various formulas to calculate the 1st of month - then first friday in month - in the first section for week1
then simply adding 3 and 7 days
in the 5th week test to see if there are 5 weeks and then show the start and end of for that week

the days of the week are also calculated using a formula
see if this works for you at all - what version of excel are you using
see attached "week calculator"

I have changed to use text for the dates B1 and B2 now
so you just type 2014 and month March etc - see attached "week calculator text"

so this displays first working day of the month - using text as input for dates

BUT notice August as a friday is the 1st it calculate 8th as friday - I guess you do not want that - correct ?
see attached V2

I have changed so that if friday is the 1st for start week - then friday will be the 1st for end week - for week1
see attached v3

your welcome
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here

combatlan it may be worth starting a thread of your own and post the link to here
so others may also see an answer