hello - im hoping someone will be able to help me!
on one sheet within my workbook I have a column with the week numbers in then the other columns with the working days date in - so for instance the first row is - week 40, 30/09/2013, 01/10/2013, 02/10/2013, 03/10/2013, 04/10/2013 and then the next row is week 41 etc.
so what I want on my working sheet is - one cell I select from a drop down list (kind of irrelevant!) the week number - and I want the rest of that row to display the dates for that week.
im sure there must be some easy formula to do this but just cannot work it out!
Be glad of someones help! MANY THANKS!
Bookmarks