Make some formulas to convert these into Excel date formats. I will point out some things: Assume each quarter starts on the first of the first month of the corresponding quarter. So Week 1 of quarter 4 is October 1. (This causes some problems for finding exact dates, but we’ll assume this for this assignment.). What are the formulae you got? Your formulae should work for any date that I enter, even if it’s not in the provided list. That is, it should be able to be repeated. Upload your spreadsheet. (Hint, once you extract the parts of your date which include [month, day, year], you might want to use the function “DATE()” to make them back into a proper date)

Day forecast was made FY14Q3W10 FY14Q3W11 FY14Q3W12 FY14Q3W13 FY14Q4W1 FY14Q4W2 FY14Q4W3 FY14Q4W4 FY14Q4W5 FY14Q4W6 FY14Q4W7 FY14Q4W8 FY14Q4W9 FY14Q4W10 FY14Q4W11 FY14Q4W12 FY14Q4W13 FY15Q1W1 FY15Q1W2 FY15Q1W3 FY15Q1W4 FY15Q1W5 FY15Q1W6 FY15Q1W7 FY15Q1W8 FY15Q1W9 FY15Q1W10 FY15Q1W11 FY15Q1W12 FY15Q1W13