Question: Make some formula s to convert these into Excel date formats. Things to consider: 1. Assume each quarter starts on the first of the first
Make some formulas to convert these into Excel date formats.
Things to consider:
1. 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 in finding exact dates, but well assume this)
2. What are the formulas you got? Your formulas should work for any date that is entered, even if its not in the provided list. That is, it should be able to be repeated.
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.
Data:
| 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 |
| FY15Q2W1 |
| FY15Q2W2 |
| FY15Q2W3 |
| FY15Q2W4 |
| FY15Q2W5 |
| FY15Q2W6 |
| FY15Q2W7 |
| FY15Q2W8 |
| FY14Q3W5 |
| FY14Q3W6 |
| FY14Q3W7 |
| FY14Q3W8 |
| FY14Q3W9 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help