Spreadsheet: 57204d1257346632-date-format-quarter-and-fiscal-year-sample-quarter-date-question
Sheet: Data

Invoice Date | Item Number | Customer Name | Unit Sales | Gross Sales | Gross Profit | Month & Year | Quarter
2007-01-25 00:00:00 | Widget 1 | [NAME] | 9382 | 84438 | 25331
2009-04-05 00:00:00 | Widget 2 | [NAME] | 30781 | 123124 | 36937 |  |  |  |  | Date | Quarter
2009-07-08 00:00:00 | Widget 3 | [NAME] | 25060 | 526260 | 157878 |  |  |  |  | 2007-01-01 00:00:00 | Q1 - 2007
2008-05-02 00:00:00 | Widget 4 | [NAME] | 25958 | 493202 | 147961 |  |  |  |  | 2007-02-01 00:00:00 | Q1 - 2007
2009-12-12 00:00:00 | Widget 5 | [NAME] | 12635 | 202160 | 60648 |  |  |  |  | 2007-03-01 00:00:00 | Q1 - 2007
2007-01-04 00:00:00 | Widget 6 | [NAME] | 30919 | 742056 | 222617 |  |  |  |  | 2007-04-01 00:00:00 | Q2 - 2007
2007-02-04 00:00:00 | Widget 7 | ZEK 2 | 29758 | 297580 | 89274 |  |  |  |  | 2007-05-01 00:00:00 | Q2 - 2007
2008-08-12 00:00:00 | Widget 8 | ZEK 2 | 10615 | 169840 | 50952 |  |  |  |  | 2007-06-01 00:00:00 | Q2 - 2007
2009-09-12 00:00:00 | Widget 9 | ZEK 2 | 23275 | 535325 | 160598 |  |  |  |  | 2007-07-01 00:00:00 | Q3 - 2007
2008-04-05 00:00:00 | Widget 10 | ZEK 2 | 30629 | 459435 | 137831 |  |  |  |  | 2007-09-01 00:00:00 | Q3 - 2007
2007-06-05 00:00:00 | Widget 11 | ZEK 2 | 24633 | 320229 | 96069 |  |  |  |  | 2007-11-01 00:00:00 | Q4 - 2007
2009-08-08 00:00:00 | Widget 4 | ZEK 2 | 17052 | 255780 | 76734 |  |  |  |  | 2007-12-01 00:00:00 | Q4 - 2007
2009-09-10 00:00:00 | Widget 5 | JUM 4 | 29273 | 175638 | 52691 |  |  |  |  | 2008-01-01 00:00:00 | Q1 - 2008
2008-04-05 00:00:00 | Widget 6 | JUM 4 | 16328 | 293904 | 88171 |  |  |  |  | 2008-02-01 00:00:00 | Q1 - 2008
2008-10-09 00:00:00 | Widget 7 | JUM 4 | 14174 | 297654 | 89296 |  |  |  |  | 2008-03-01 00:00:00 | Q1 - 2008
2007-11-08 00:00:00 | Widget 8 | JUM 4 | 17831 | 53493 | 16048 |  |  |  |  | 2008-04-01 00:00:00 | Q2 - 2008
2008-11-08 00:00:00 | Widget 7 | JUM 4 | 29027 | 609567 | 182870 |  |  |  |  | 2008-05-01 00:00:00 | Q2 - 2008
2008-11-08 00:00:00 | Widget 8 | JUM 4 | 32574 | 488610 | 146583 |  |  |  |  | 2008-06-01 00:00:00 | Q2 - 2008
2007-12-01 00:00:00 | Widget 9 | JUM 4 | 18136 | 417128 | 125138 |  |  |  |  | 2008-07-01 00:00:00 | Q3 - 2008
2007-03-11 00:00:00 | Widget 1 | [NAME] | 13135 | 118213 | 35464 |  |  |  |  | 2008-08-01 00:00:00 | Q3 - 2008
2009-05-20 00:00:00 | Widget 2 | [NAME] | 43093 | 172374 | 51712 |  |  |  |  | 2008-09-01 00:00:00 | Q3 - 2008
2009-08-22 00:00:00 | Widget 3 | [NAME] | 35084 | 736764 | 221029 |  |  |  |  | 2008-10-01 00:00:00 | Q4 - 2008
2008-06-16 00:00:00 | Widget 4 | [NAME] | 36341 | 690483 | 207145 |  |  |  |  | 2008-11-01 00:00:00 | Q4 - 2008
2007-02-18 00:00:00 | Widget 6 | [NAME] | 43287 | 1038878 | 311663 |  |  |  |  | 2008-12-01 00:00:00 | Q4 - 2008
2007-03-21 00:00:00 | Widget 7 | ZEK 2 | 41661 | 416612 | 124984 |  |  |  |  | 2009-01-01 00:00:00 | Q1 - 2009
2008-09-26 00:00:00 | Widget 8 | ZEK 2 | 14861 | 237776 | 71333 |  |  |  |  | 2009-02-01 00:00:00 | Q1 - 2009
2009-10-27 00:00:00 | Widget 9 | ZEK 2 | 32585 | 749455 | 224837 |  |  |  |  | 2009-04-01 00:00:00 | Q2 - 2009
2008-05-20 00:00:00 | Widget 10 | ZEK 2 | 42881 | 643209 | 192963 |  |  |  |  | 2009-05-01 00:00:00 | Q2 - 2009
2007-07-20 00:00:00 | Widget 11 | ZEK 2 | 34486 | 448321 | 134496 |  |  |  |  | 2009-07-01 00:00:00 | Q3 - 2009
2009-09-22 00:00:00 | Widget 4 | ZEK 2 | 23873 | 358092 | 107428 |  |  |  |  | 2009-08-01 00:00:00 | Q3 - 2009
2009-10-25 00:00:00 | Widget 5 | JUM 4 | 40982 | 245893 | 73768 |  |  |  |  | 2009-09-01 00:00:00 | Q3 - 2009
2008-05-20 00:00:00 | Widget 6 | JUM 4 | 22859 | 411466 | 123440 |  |  |  |  | 2009-10-01 00:00:00 | Q4 - 2009
2008-11-23 00:00:00 | Widget 7 | JUM 4 | 19844 | 416716 | 125015 |  |  |  |  | 2009-11-01 00:00:00 | Q4 - 2009
2007-12-23 00:00:00 | Widget 8 | JUM 4 | 24963 | 74890 | 22467 |  |  |  |  | 2009-12-01 00:00:00 | Q4 - 2009
2008-12-23 00:00:00 | Widget 7 | JUM 4 | 40638 | 853394 | 256018
2008-12-23 00:00:00 | Widget 8 | JUM 4 | 45604 | 684054 | 205216
2008-01-15 00:00:00 | Widget 9 | JUM 4 | 25390 | 583979 | 175194
 | Widget 1 | [NAME] | 9382 | 84438 | 25331
 | Widget 2 | [NAME] | 30781 | 123124 | 36937
 | Widget 3 | [NAME] | 25060 | 526260 | 157878
 | Widget 4 | [NAME] | 25958 | 493202 | 147961
 | Widget 6 | [NAME] | 30919 | 742056 | 222617
 | Widget 7 | ZEK 2 | 29758 | 297580 | 89274
 | Widget 8 | ZEK 2 | 10615 | 169840 | 50952
 | Widget 9 | ZEK 2 | 23275 | 535325 | 160598
 | Widget 10 | ZEK 2 | 30629 | 459435 | 137831
 | Widget 11 | ZEK 2 | 24633 | 320229 | 96069
 | Widget 4 | ZEK 2 | 17052 | 255780 | 76734
 | Widget 5 | JUM 4 | 29273 | 175638 | 52691
 | Widget 6 | JUM 4 | 16328 | 293904 | 88171
 | Widget 7 | JUM 4 | 14174 | 297654 | 89296
 | Widget 8 | JUM 4 | 17831 | 53493 | 16048
 | Widget 7 | JUM 4 | 29027 | 609567 | 182870
 | Widget 8 | JUM 4 | 32574 | 488610 | 146583
 | Widget 9 | JUM 4 | 18136 | 417128 | 125138
 | Widget 1 | [NAME] | 13135 | 118213 | 35464
 | Widget 2 | [NAME] | 43093 | 172374 | 51712
 | Widget 3 | [NAME] | 35084 | 736764 | 221029
 | Widget 4 | [NAME] | 36341 | 690483 | 207145
 | Widget 6 | [NAME] | 43287 | 1038878 | 311663
 | Widget 7 | ZEK 2 | 41661 | 416612 | 124984
 | Widget 8 | ZEK 2 | 14861 | 237776 | 71333
 | Widget 9 | ZEK 2 | 32585 | 749455 | 224837
 | Widget 10 | ZEK 2 | 42881 | 643209 | 192963
 | Widget 11 | ZEK 2 | 34486 | 448321 | 134496
 | Widget 4 | ZEK 2 | 23873 | 358092 | 107428
 | Widget 5 | JUM 4 | 40982 | 245893 | 73768
 | Widget 6 | JUM 4 | 22859 | 411466 | 123440
 | Widget 7 | JUM 4 | 19844 | 416716 | 125015
 | Widget 8 | JUM 4 | 24963 | 74890 | 22467
 | Widget 7 | JUM 4 | 40638 | 853394 | 256018
 | Widget 8 | JUM 4 | 45604 | 684054 | 205216
 | Widget 9 | JUM 4 | 25390 | 583979 | 175194