Return dates based on week selected

Hi I have a week by week calendar that needs to display the week start date and end date based on a week selection.

please see attached sheet for details.

Thanks in advance

JD

No sure if this is what you were expecting, but have a look.

Cheers,

Date Selector.xlsx

Kind of, i was looking just to have one drop down box with a week selector and then the dates to fill from that selection, If the column headres need to be changed to accommodate this then i am ok with that.

Basically select one week and both dates to automaically fill into the relevent cells

Cheers

JD

OK second attempt and I think this is what you're looking for:

Date Selector01.xlsx

Cheers

PS. Please mark as SOLVED if you're happy with the result

This can be done but we would have to rework the spreadsheet. Unfortunately, it's late Wednesday evening here where I am and I'll be away until Monday.

I'll try and get back to it then.

Cheers,

thank you i will post an example sheet of the requirement.

jd

Hi John,

I've been thinking about the situation you proposed in post #5 and as mentioned then the whole spreadsheet would have to be totally changed in its layout. Excel can't guess, it can only work on information/data provided. We would also need to go back to my first example and have two or more data validation drop-down lists.

Give it some thought and get back to me.

Cheers,

The matches would be the initial start date in say cell A1 and then the week numbers say (A2) 2.1 and (A3) 2.2 to give the week beginnning and ending in correspondence of the start date. The dates would then be matched to the prefix 2.1 and 2.2 using the start date as lookup start value.

JD

Hi John, can you please upload a sample of your new thoughts

Here you go the details are explained in the Workbook.

Thnaks in advance

JDDate Selector.xlsx

So which input criteria do you want to use: a date or a week number? Do you want to know the Week Start/End dates based on a selected Week or based on a date (even though the date may or not be the exact Start/End date). Because the spreadsheet you uploaded shows both: a "Start Date" AND "Week 2 Start", "Week 2 End" but I don't see why both are required because if you simply put in the week number the date appears.

Have a look at this one: simply by selecting a week # (cell B7) the dates appear in B8, B9.

Date Selector02.xlsx

I need the user to put in the week 1 start date as the reference to look for the entered weeks. So if the user entered the start date (A1) then then week no (say week 7) then the dates for the week 7 Start and week 7 end would be displayed.

I would be using multiple rows of dates that would need to matched against from the starting point of the week 1 start date and then display the dates relevent to the chosen week.

Where you have Select Week # on your sheet that would be select start date and then then enter a week number to look up so it would use 2 sets of criteria to match against the week7 start and then the week 7 end.

Phew ... Hope that is clear enough LOL.

Cheers
JD

Brilliant thats exactly what I need many thanks.....A++++++++++++

Well done - good we finally got there, and thanks ACE