Spreadsheet: 60228d1260806393-fiscal-quarter-year-into-a-date-format-qtrs-in-order
Sheet: Sample sales 

Year | 2008-01-01 00:00:00
Sum of Gross Sales | Column Labels
Row Labels | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | Grand Total
Product 1 | 303497.47476 | 191906.60156 | 423038.5852800001 | 498062.69924 | 263622.90419 | 429426.84623 | 196543.04141 | 251937.69188 | 464955.37386 | 336655.91503 | 402761.0478099999 | 217896.88221 | 3980305.063459999
Product 10 | 17136.45 | 30471.72 | 73838.34 | 25011.45 | 25145.93 | 155187.86 | 63174.67999999999 | 27085.2 |  |  |  |  | 417051.63
Product 11 | 117773.916 | 15613.86619999999 | 340084.38 | 59139.82099999999 | 143557.627 | 74874.63999999998 | 135230.64 | 654567.2849999999 | 209070.98 | 39325.919 | 208932.712 | 134914.411 | 2133086.1972
Product 12 | 1990.8 | 1824.9 | 8118.27 | 1659 | 5474.7 | 6387.150000000001 | 4432.95 | 8000.289999999999 | 8091.68 | 4470.91 | 497.7 |  | 50948.35000000001
Product 13 | 2571.03 | 378.84 | 40559.41999999999 | 50040.21 | 2638.02 | 25965.62999999999 | 3035.34 | 51114.32999999999 | 36550.03 | 4264.26 | 2594.13 | 307.23 | 220018.47
Product 15 | 33449.8 | 72827.685 | 16387.58 | 115787.37 | 111225.81 | 3820.505 | 68071.77999999998 | 49372.62 | 123160.37 | 125493.33 | 89819.2 | 81213.49 | 890629.5399999998
Product 16 | 10830.6 | 25311.2 | 35167 | 18319.29 | 64845 | 101608.4 | 39955.25 | 54470.50000000001 | 44908.1 | 10769.2 |  | 23435.6 | 429620.14
Product 19 | 989258.7550000001 | 530000.095 | 461280.65 | 592010.515 | 617082.93 | 463097.1100000001 | 667176.6200000002 | 298160.72 | 494907.1800000001 | 649261.1600000003 | 557892.836 | 572647.49 | 6892776.061000001
Product 2 | 35346.87 | 243974.3 | 101319.3 | 81662.46 | 107404.71 | 57150.535 | 115894.26 | 119713.725 | 96953.81999999999 | 106730.955 | 74726.04 | 98656.68499999998 | 1239533.66
Product 20 | 23831.82 | 38878.48 | 51391.55 | 34974.72 | 22002.97 | 24409.25 | 7006.55 | 5052.42 | 5674.1 | 54929.24 | 21438.29 | 93118.73000000001 | 382708.12
Product 21 |  | 3525.12 | 5287.68 | 3477.6 | 5216.4 |  | 2898 | 3477.6 | 3477.6 | 1738.8 |  | 6259.679999999999 | 35358.48
Product 23 |  |  | 36614.02499999999 | 12204.675 | 12998.475 | 13395.375 | 14586.075 | 29965.95 |  | 47330.325 |  | 26790.75 | 193885.65
Product 24 | 260028.23 | 386535.76 | 231759.06 | 173414.81 | 189546.0699999999 | 292876.1184 | 177395.27 | 186132.7168 | 283490.3284000001 | 199172.68 | 307239.69 | 280373.87 | 2967964.6036
Product 3 | 6190.08 |  | 31079.16 | 2928.03 | 757.44 | 34114.99 | 715.68 | 743.76 |  | 57309.03000000001 | 2290.92 | 1839.6 | 137968.69
Product 5 |  |  | 22189.2 | 41802 | 21132.65 | 6318.39 |  |  |  | 15445.7125 |  |  | 106887.9525
Product 8 |  |  |  |  |  |  |  |  |  |  | 36977.1 | 66078.55 | 103055.65
Grand Total | 1801905.82576 | 1541248.56776 | 1878114.20028 | 1710494.65024 | 1592651.63619 | 1688632.79963 | 1496116.13641 | 1739794.80868 | 1771239.56226 | 1652897.43653 | 1705169.66581 | 1603532.96821 | 20181798.25776
Year | 2009-01-01 00:00:00
Sum of Gross Sales | Column Labels
Row Labels | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | Grand Total
Product 1 | 381323.9881799999 | 338859.08609 | 576500.2121400001 | 297380.5414100001 | 313155.68774 | 659416.62997 | 491603.95454 | 418893.15913 | 548794.8007199999 | 959598.8024400002 | 507456.1881799999 | 90936.27 | 5583919.32054
Product 11 | 354124.91 | 142502.02 | 372099.6339999999 | 404548.6999999999 | 190397.73 | 669716.9400000001 | 296054.66 | 433714.708 | 243892.24 | 271017.19 | 242807.908 | 14720.22 | 3635596.86
Product 12 |  |  | -77.88 | 9193.789999999999 | 5915.81 |  | 16590 | 1153.49 |  | 1161.44 |  |  | 33936.65
Product 13 | 1764.84 | 38064.71999999999 | 3404.94 | 3042.27 | 24748.21 | 3444.21 | 4097.940000000001 | 18514.4 | 22211.16 | 2349.27 | 15027.76 | 9.24 | 136678.96
Product 15 | 42691.5 | 131664.24 | 121120.6 |  | 56082.92 | 16850.43 | 128690.63 | 116013.66 | 6197.63 | 72649.96 | 20907.21 |  | 712868.7799999999
Product 16 | 28295.9 | 6276.6 | 23425.8 | 21328.2 | 31471.1 | 22649 | 33151 | 56224.3 | 93913.6 | 32499.5 | 16850.7 | 11750 | 377835.7
Product 19 | 635536.4400000001 | 371271.71 | 555584.8800000001 | 215099.33 | 285994.6200000001 | 261757.04 | 461053.7600000001 | 297702.42 | 896416.61 | 711834.0499999999 | 650153.5199999999 | 56507.5 | 5398911.88
Product 2 | 86122.00000000001 | 58293.53499999999 | 89220.44 | 136607.205 | 69172.98499999999 | 147616.17 | 100116.385 | 86553.23 | 88674.35999999999 | 69526.42499999999 | 81661.2 | 13330.02 | 1026893.955
Product 20 | 39944.97000000001 | 36562.94 | 6869.55 | 18452.19 | 11173.44 | 14929.92 | 23998.26 | 12472.32 | 17908.46 | 23623.18 | 10964.57 |  | 216899.8
Product 23 |  |  | 27176.85 |  | 12601.575 | 14033.25 |  | 15984 | 31660.875 | 13986 | 13097.7 |  | 128540.25
Product 24 | 224161.65 | 141330.44 | 204917.2 | 146059.14 | 347327.95 | 301260.8300000001 | 401142.35 | 307154.48 | 176755.88 | 354703.39 | 229882.43 | 10567.68 | 2845263.42
Product 3 | 5704.8 | 2895.24 | 5149.67 | 16380 | 4804.8 | 9614.880000000001 | 7509.21 | 4017.6 | 4756.799999999999 | 1769.4 |  |  | 62602.4
Product 5 |  |  |  |  |  |  |  |  |  | 5474.15 | 771.66 |  | 6245.809999999999
Product 8 | 9520.52 | 82075.57 | 97029.92 | 135317.86 | 127358.5 | 75386.20000000001 | 119479.89 | 56313.75 | 94443.15000000001 | 93567.64 | 59941.09000000001 | 37107.3752 | 987541.4652000001
Grand Total | 1809191.51818 | 1349796.10109 | 2082421.81614 | 1403409.22641 | 1480205.32774 | 2196675.49997 | 2083488.03954 | 1824711.51713 | 2225625.565719999 | 2613760.39744 | 1849521.93618 | 234928.3052 | 21153735.25074
Year | (All)
 |  |  |  | These are out of order |  |  |  | It should be Q1CY08, Q2CY08, Q3CY08, etc…
Sum of Gross Sales | Column Labels
Row Labels | Q1CY08 | Q1CY09 | Q2CY08 | Q2CY09 | Q3CY08 | Q3CY09 | Q4 CY07 | Q4 CY09* | Q4CY08 | Grand Total
Product 1 | 918442.6616 | 1296683.28641 | 1191112.44966 | 1269952.85912 | 913436.10715 | 1459291.914389999 | 788067.7720100002 | 1557991.26062 | 957313.8450500001 | 10352292.15601
Product 10 | 121446.51 |  | 205345.24 |  | 90259.88000000002 |  | 39318.3 |  |  | 456369.93
Product 11 | 473472.1622 | 868726.5639999999 | 277572.0879999999 | 1264663.37 | 998868.9050000001 | 973661.6080000001 | 637883.5865000001 | 528545.3180000001 | 383173.0420000001 | 6406566.643700001
Product 12 | 11933.97 | -77.88 | 13520.85 | 15109.6 | 20524.92 | 17743.49 | 15368.13 | 1161.44 | 4968.61 | 100253.13
Product 13 | 43509.29 | 43234.5 | 78643.86 | 31234.69 | 90699.69999999998 | 44823.49999999999 | 53252.64999999999 | 17386.27 | 7165.619999999999 | 409950.0800000001
Product 15 | 122665.065 | 295476.34 | 230833.685 | 72933.35 | 240604.77 | 250901.92 | 264878.855 | 93557.17 | 296526.02 | 1868377.175
Product 16 | 71308.79999999999 | 57998.3 | 184772.69 | 75448.3 | 139333.85 | 183288.9 | 74714.48 | 61100.2 | 34204.8 | 882170.32
Product 19 | 1980539.5 | 1562393.03 | 1672190.555 | 762850.99 | 1460244.520000001 | 1655172.79 | 1812597.904 | 1418495.07 | 1779801.486 | 14104285.845
Product 2 | 380640.4700000002 | 233635.9750000001 | 246217.705 | 353396.3599999999 | 332561.8050000001 | 275343.975 | 248265.305 | 164517.645 | 280113.68 | 2514692.92
Product 20 | 114101.85 | 83377.46000000002 | 81386.94 | 44555.55 | 17733.07 | 54379.03999999999 | 88092.98000000003 | 34587.75 | 169486.26 | 687700.9
Product 21 | 8812.800000000001 |  | 8694 |  | 9853.2 |  | 6141.42 |  | 7998.48 | 41499.90000000001
Product 23 | 36614.02499999999 | 27176.85 | 38598.525 | 26634.825 | 44552.02499999999 | 47644.875 | 73076.84999999999 | 27083.7 | 74121.075 | 395502.75
Product 24 | 878323.0499999999 | 570409.29 | 655836.9983999998 | 794647.9200000002 | 647018.3152000001 | 885052.7100000003 | 767238.3300000001 | 595153.5000000002 | 786786.24 | 6580466.3536
Product 3 | 37269.24000000001 | 13749.71 | 37800.46 | 30799.68 | 1459.44 | 16283.61 | 67263.34 | 1769.4 | 61439.55 | 267834.43
Product 5 | 22189.2 |  | 69253.04000000001 |  |  |  |  | 6245.81 | 15445.7125 | 113133.7625
Product 8 |  | 188626.01 |  | 338062.56 |  | 270236.79 |  | 190616.1052 | 103055.65 | 1090597.1152
Grand Total | 5221268.593800001 | 5241409.435409999 | 4991779.086060001 | 5080290.05412 | 5007150.507350002 | 6133825.12239 | 4936159.90251 | 4698210.638820001 | 4961600.070550001 | 46271693.41101