Spreadsheet: 816008d1675305593-running-total-percent-ignore-incomplete-data-samplecalendar
Sheet: Calendar with IF statements

 | 2023 DAILY SALES TRACKER
 | January 2023 |  |  |  | 2022 Sales Dept |  | 2023 Sales Dept |  | % Diff |  | 2022 Monthly Total |  | 2023 Monthly Total |  | % Difference
 | SUNDAY |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY |  | WEEKLY TOTALS
 | 2023-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales |  | [NAME]
 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | YOY
 | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept
 | 12712 | 18599 | 364242 | 48786 | 349914 | 474538 | 365238 | 443482 | 399545 | 508300 | 397760 | 420037 | 6789 | 20073
 | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales
 | 42685 | 53954 | 472196 | 115579 | 485384 | 575652 | 495462 | 568913 | 534235 | 613118 | 516026 | 521511 | 56803 | 69444
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales |  | [NAME]
 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | YOY
 | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept
 | 8174 | 12070 | 390700 | 522777 | 449836 | 537951 | 350610 | 502373 | 343959 | 484152 | 292727 | 430550 | 8639 | 18507
 | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales
 | 61286 | 51660 | 551432 | 635402 | 590362 | 658893 | 493624 | 610619 | 475511 | 587631 | 412390 | 528744 | 55061 | 59729
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales |  | [NAME]
 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | YOY
 | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept
 | 5210 | 12692 | 326216 | 343201 | 320179 | 465313 | 400243 | 474436 | 428287 | 474800 | 290765 | 437353 | 8745 | 14573
 | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales
 | 45604 | 53839 | 428528 | 444531 | 441427 | 565772 | 521943 | 586654 | 585034 | 587465 | 397547 | 547054 | 50362 | 58320
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales |  | [NAME]
 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 | YOY
 | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept
 | 13944 | 8303 | 370407 | 548744 | 381466 | 510481 | 413779 | 506304 | 425204 | 555224 | 307178 | 431664 | 13006 | 25086
 | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales
 | 44780 | 57293 | 487426 | 676832 | 511167 | 627385 | 545899 | 621929 | 540628 | 668165 | 409424 | 522451 | 48926 | 66540
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales |  | [NAME]
 | 2022 | 2023 | 2022 | 2023 | 2022 | 2023 |  |  |  |  |  |  |  |  | 2022 | 2023 | YOY
 | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept | Sales Dept |  |  |  |  |  |  |  |  | Sales Dept | Sales Dept
 | 10202 | 11285 | 368598 |  | 413737
 | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales | Total Sales |  |  |  |  |  |  |  |  | Total Sales | Total Sales
 | 41742 | 58526 | 479009 |  | 551247