Choose a Months, and Cells change to those dates Formula

[ashhm]

I have a workbook that contains 7 sheetsfor the days of the week. Monday, Tuesday etc. On those sheets I have 4 to 5 columns of the days of the month. So Monday's sheet contains All Monday dates 3, 10, 17, 24. I would like toHave a drop down which I can choose a month, and then the dates for those columns on each sheet change to the correct dates. I have the drop down but I am not sure how to link those cells and the drop down to a calendar. Any help will be greatly appreciated. Thank You!!

[Bob Phillips]

For the Monday sheet, assuming B1 for first Monday

B1: =DATEVALUE("06-"&monthInput&"-2012")-WEEKDAY(DATEVALUE("06-"&monthInput&"-2012"),2)+1
C1: = IF(MONTH(B1)=MONTH(B1+7),MONTH(B1+7,"")
copy C1 to D1:F1

On Tuesday

B1: =Monday!B1+1
C1: =IF(Monday!C1<>"",Monday!C1,"")
copy C1 to D1:F1

Wed-Fri, ditto

[ashhm]

The only thing is tough it goes from Monday to Saturday. And how do I connect the drop down to the first cell with the right date?

[Bob Phillips]

I don't understand the question.

[ashhm]

I got it. Thank you!

[Cutter]

@ ashhm

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.