Hi im new to formulas and cant get my head round it.
I have a table with the information I need in sheet 1 and a print off sheet called engineer on call. What I need to do in cell B3 is pick up the week no from 1 to 52. In Cell A6 pick up the 1st date of that corresponding week. In Cell C6 pick up the 2nd date of that corresponding week and in cells A9 and A10 enter the engineer name and phone number. Ideally I want the sheet to automatically enter all the information in those cells by entering the week number only in cell B3.
