In cell A1, I have a year and cell A2, I have a week number. Lets say A1 contains 2008 and A2 contains week #3, how do I get the Friday date of the third week of the year 20058 I don't need any VBA code snippets. I just need the formula. In this case, the answer for this would be 01/18/2008 because its the third friday of the year.
Note, I don't want to add any add-on packs or anything. Simple functions to get me what I want.