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