Spreadsheet: 92940d1292450474-fytd-totals-based-on-current-date-excel-example
Sheet: Example

 |  | 2009-10-01 00:00:00 | 2010-10-01 00:00:00 | Change | Budget | % to Budget | 2009-11-01 00:00:00 | 2010-11-01 00:00:00 | Change | Budget | % to Budget | 2009-12-01 00:00:00 | 2010-12-01 00:00:00 | Change | Budget | % to Budget | 2010-01-01 00:00:00 | 2011-01-01 00:00:00 | Change | Budget | % to Budget | 2010-02-01 00:00:00 | 2011-02-01 00:00:00 | Change | Budget | % to Budget | 2010-03-01 00:00:00 | 2011-03-01 00:00:00 | Change | Budget | % to Budget | 2010-04-01 00:00:00 | 2011-04-01 00:00:00 | Change | Budget | % to Budget | 2010-05-01 00:00:00 | 2011-05-01 00:00:00 | Change | Budget | % to Budget | 2010-06-01 00:00:00 | 2011-06-01 00:00:00 | Change | Budget | % to Budget | 2010-07-01 00:00:00 | 2011-07-01 00:00:00 | Change | Budget | % to Budget | 2010-08-01 00:00:00 | 2011-08-01 00:00:00 | Change | Budget | % to Budget | 2010-09-01 00:00:00 | 2011-09-01 00:00:00 | Change | Budget | % to Budget | 2010 FY | 2011 FY | Change | Budget | % to Budget
Widgets | Units SUM | 248116 | 246712 |  | 253365.91 |  | 211498 | 229955 |  | 215906.165 |  | 214752 |  |  | 217908.14 |  | 236286 |  |  | 242563.145 |  | 215388 |  |  | 221279.67 |  | 249461 |  |  | 256170.84 |  | 239961 |  |  | 246516.6249999999 |  | 245265 |  |  | 251864.6949999999 |  | 256089 |  |  | 238821.27515 |  | 267984 |  |  | 234744.6853135 |  | 255608 |  |  | 231505.799347065 |  | 268795 |  |  | 229039.8979944974
 | Gallons | 381380.5 | 379561.5 |  | 387975.405 |  | 334270.5 | 350613.5 |  | 339553.9300000001 |  | 338033.5 |  |  | 336998.4775 |  | 361645 |  |  | 373846.3875000001 |  | 338771 |  |  | 350678.0525 |  | 384534 |  |  | 397690.83 |  | 371847 |  |  | 384855.71 |  | 373998 |  |  | 386608.72 |  | 383379.5 |  |  | 360013.0558500001 |  | 396659 |  |  | 354358.7564915 |  | 390020 |  |  | 353811.4895228849 |  | 405632 |  |  | 356704.2407418431
 | Dollars SUM | 616294.1900000001 | 583825.1 |  | 628307.0023500001 |  | 531636.56 | 558525.31 |  | 541523.9647000001 |  | 532016 |  |  | 535039.1941 |  | 580117.21 |  |  | 598460.0604000001 |  | 545693.35 |  |  | 563836.0894 |  | 611961.13 |  |  | 631716.7161000001 |  | 589354.43 |  |  | 608496.2394 |  | 572331.3 |  |  | 590736.3546 |  | 580389.33 |  |  | 564848.65622 |  | 589879.86 |  |  | 556965.68771665 |  | 585446.71 |  |  | 557332.6922503733 |  | 601043.06 |  |  | 560864.9856763525
 | Product Margin $ | 207931.79 | 120711.3 |  | 212562.1213500001 |  | 162316.02 | 121748.26 |  | 166003.6882500001 |  | 140765.41 |  |  | 144449.7504 |  | 133266.11 |  |  | 136389.5721999999 |  | 119225.43 |  |  | 122264.9563500002 |  | 159557.89 |  |  | 163833.9905500001 |  | 163555.15 |  |  | 167768.9083 |  | 126338.25 |  |  | 129842.54715 |  | 97654.78 |  |  | 138506.8681615 |  | 76453 |  |  | 137606.2174446851 |  | 92136.85 |  |  | 139450.608382895 |  | 100904.34 |  |  | 141636.5195219781
Super Widgets | Units SUM | 99863 | 95379 |  | 49860.55 |  | 118044 | 118554 |  | 72289.1 |  | 129551 |  |  | 84478.955 |  | 92629 |  |  | 47032.58 |  | 100363 |  |  | 53024.64000000001 |  | 114101 |  |  | 57181.64999999999 |  | 109150 |  |  | 56260.52 |  | 96849 |  |  | 50264.205 |  | 90031 |  |  | 51672.4495 |  | 85162 |  |  | 51685.108 |  | 84548 |  |  | 51807.658 |  | 92443 |  |  | 52301.0635
 | Gallons | 59059 | 57937.5 |  | 31766.9 |  | 67609.5 | 68929 |  | 42628.915 |  | 72816.5 |  |  | 48441.10750000001 |  | 52312.5 |  |  | 26686.63 |  | 57835.5 |  |  | 31184.40000000001 |  | 68504.5 |  |  | 34764.645 |  | 64898.5 |  |  | 34225.285 |  | 56740.5 |  |  | 29711.4825 |  | 54682 |  |  | 31362.882875 |  | 52668 |  |  | 31369.212125 |  | 50495 |  |  | 31430.487125 |  | 56339 |  |  | 31677.189875
 | Dollars SUM | 467856.05 | 600345 |  | 302908.16445 |  | 522415.95 | 689003.52 |  | 370801.62235 |  | 578599.6 |  |  | 428311.7877 |  | 461160.19 |  |  | 292855.6582000001 |  | 517235.92 |  |  | 339584.3547 |  | 595849.98 |  |  | 368400.6920000001 |  | 572617.56 |  |  | 367847.7092 |  | 512217.28 |  |  | 329002.6066 |  | 503766.74 |  |  | 328676.4847625 |  | 485150.8 |  |  | 328706.7838525 |  | 483597.01 |  |  | 329413.7738525 |  | 551193.65 |  |  | 332316.3564025
 | Product Margin $ | 66776.19 | 53439.67 |  | 6446.366850000049 |  | 81793.98 | 75401.91 |  | 28031.43794999993 |  | 79993.11 |  |  | 29543.17045000003 |  | 71684.21 |  |  | 17194.18540000007 |  | 67109.22 |  |  | 9804.889899999951 |  | 76732.1 |  |  | 3865.725800000073 |  | 76040.73 |  |  | 7727.984600000083 |  | 68568.55 |  |  | 8991.15664999996 |  | 57900.11 |  |  | 6282.818666249979 |  | 56031.65 |  |  | 6255.446031249943 |  | 51716.28 |  |  | 6310.560031249945 |  | 52528.13 |  |  | 8203.649008749984