Spreadsheet: 85140d1285191998-excel-2007-to-show-the-12-oldest-dates-then-return-its-row-contents-mrexcelexample
Sheet: Loan Data

Price | Item | Category | Notes | Customer Name | ID Number | ID Type | Buyer ID | Loan Date | Due Date | Empty | Loan ID #
9000 | Apprentice Reciprocating Saw | TOOLS | Black Case Bunk 3 | [NAME] | 6546546 | Voluntary ID | SN1 | 2009-12-15 00:00:00 | 2010-01-12 00:00:00 |  | 101004101
2463 | [NAME] in box | HOME AUDIO |  | [NAME] | 654654 | PEI Drivers | SN1 | 2009-08-18 00:00:00 | 2010-01-12 00:00:00 |  | 101003401
65 | BLACK AND DECKER SANDER | TOOLS | Loose by tool area | [NAME] | 53 | PEI Drivers | LA1 | 2009-12-14 00:00:00 | 2010-01-18 00:00:00 |  | 101002901
56 | [NAME] | tools | bunk 2 | [NAME] | 654654 | Voluntary ID | CB1 | 2009-12-24 00:00:00 | 2010-01-21 00:00:00 |  | 101008201
546 | ridgid tools | Tools | in orange/black ridgid bag | [NAME] | 646 | PEI Drivers | KW1 | 2009-12-29 00:00:00 | 2010-01-26 00:00:00 |  | 101010901
5416 | Dewalt- Spin Saw/ Screw gun | TOOLS | in grocery bag by tools | [NAME] | 5461 | [NAME] | LA1 | 2010-01-02 00:00:00 | 2010-01-30 00:00:00 |  | 102001901
968 | Ps2 Console | PS2 Console | in bag on CR | Sugar Love | 6546 | PEI Drivers | LA1 | 2010-01-02 00:00:00 | 2010-01-30 00:00:00 |  | 102001701
213 | Jazz HDV178 | CAMCORDER | in camera bag loans C | [NAME] | 6465 | Status Card | CB1 | 2010-01-02 00:00:00 | 2010-01-30 00:00:00 |  | 102001101
123 | 16 DVDs/Wireless keyboard/mouse | COMPUTERS | in bag(s) on CR | [NAME] | 544654 | Voluntary ID | LA1 | 2010-01-02 00:00:00 | 2010-01-30 00:00:00 |  | 102001801
456 | PS2x2 in boxes/4games | PS2 Console | in origional boxes/games in bag | [NAME] | 541131 | PE Drivers | LA1 | 2010-01-02 00:00:00 | 2010-01-30 00:00:00 |  | 102002001
789 | 2x 360 games | xbox360 | bag CR | [NAME] | 684964 | PEI Drivers | CB1 | 2010-01-04 00:00:00 | 2010-02-01 00:00:00 |  | 102002501
1122 | Curtis GPD359 | GPS | in box, CR | [NAME] | 8496546 | PEI Drivers | KW1 | 2010-01-11 00:00:00 | 2010-02-08 00:00:00 |  | 102011001
1455 | Behringer MX3282A | MUSICAL | with Power Supply | Sugar Wall Jameson | 654651 | PEI Drivers | KW1 | 2010-01-11 00:00:00 | 2010-02-08 00:00:00 |  | 102010401
1788 | Drabrnd boombox/CD plyr | home audio | SHELVES | [NAME] | 51631 | Voluntary ID | SN1 | 2010-01-11 00:00:00 | 2010-02-08 00:00:00 |  | 102011701
2121 | DVDs and [NAME] | DVD | in bag on bunk 1 | [NAME] | 546 | Voluntary ID | KW1 | 2010-01-11 00:00:00 | 2010-02-08 00:00:00 |  | 102010801
2454 | 10 dvds/jobmate tool | dvd | one bag BUNK 2 | [NAME] | 446 | Voluntary ID | SN1 | 2010-01-12 00:00:00 | 2010-02-09 00:00:00 |  | 102012801
2787 | [NAME]/b&d palm | tools | drill in case/sander TOOLS | [NAME] | as6d56 | #[NAME]! | SN1 | 2010-01-13 00:00:00 | 2010-02-10 00:00:00 |  | 102015401
3120 | 8 DVDs, 2 VHS, 2tools | DVD | black bag, bunk 2 | [NAME] | 654a6sd | Voluntary ID | KW1 | 2010-01-14 00:00:00 | 2010-02-11 00:00:00 |  | 102016401
3453 | MC Socket set/ saw blade set | TOOLS | in cases by tool section | [NAME] | 6546 | Voluntary ID | LA1 | 2010-01-15 00:00:00 | 2010-02-12 00:00:00 |  | 102013909
3786 | 2x levels, hammer | TOOLS | in tool section | Sugar Love | 879 | Voluntary ID | KW1 | 2010-01-15 00:00:00 | 2010-02-12 00:00:00 |  | 102015002
4119 | 4x board games | [NAME] | purple resuse bag beside CR | [NAME] | 849674 | Voluntary ID | SN1 | 2010-01-16 00:00:00 | 2010-02-13 00:00:00 |  | 102017801
4452 | #3 xbox 360 games/ wireless Router | Computers | in bag on CR | [NAME] | 51321 | PEI Drivers | LA1 | 2010-01-18 00:00:00 | 2010-02-15 00:00:00 |  | 102019201
4785 | Sony Explode car deck | CAR AUDIO | in origional box bunk 3 | [NAME] | 211321 | PEI Drivers | LA1 | 2010-01-18 00:00:00 | 2010-02-15 00:00:00 |  | 102019001
5118 | 40 LPs | retro | blue milk crate | [NAME] | 687496 | PEI Drivers | SN1 | 2010-01-19 00:00:00 | 2010-02-16 00:00:00 |  | 102020801
5451 | Bulova Watch/Silver jewellery | JEWELLERY | 2 X S-necklace/1xring | [NAME] | 416321 | PE Drivers | CB1 | 2010-01-25 00:00:00 | 2010-02-22 00:00:00 |  | 102026501
5784 | Dremmell tool/4 dvds | TOOLS | in bag on CR | Sugar Wall Jameson | 6746 | Voluntary ID | LA1 | 2010-01-25 00:00:00 | 2010-02-22 00:00:00 |  | 102025801
6117 | 2 x tool cases | TOOLS | 1 black/red box/1 yellow/black | [NAME] | 216321 | Voluntary ID | CB1 | 2010-01-26 00:00:00 | 2010-02-23 00:00:00 |  | 102027601
6450 | BD SET/MC DRILL/RECIP | TOOLS | 3pc/2xblue1xorange | [NAME] | 654654 | Voluntary ID | CB1 | 2010-01-28 00:00:00 | 2010-02-25 00:00:00 |  | 102029801
6783 | 2 Satellite Receivers | MISC | bag, bunk 3 | [NAME] | 654654 | PEI Drivers | KW1 | 2010-01-28 00:00:00 | 2010-02-25 00:00:00 |  | 102030701
7116 | 7 1/4" [NAME] circ saw | Tools | tools section | [NAME] | 64654 | Voluntary ID | KW1 | 2010-01-28 00:00:00 | 2010-02-25 00:00:00 |  | 102030501
7449 | ProStart Car Starter | MISC | new in box (CR) | [NAME] | 654646 | Voluntary ID | KW1 | 2010-01-30 00:00:00 | 2010-02-27 00:00:00 |  | 102033301
7782 | Lincoln Electric Welder +Mask | TOOLS | SPEED GLAS 9000x | [NAME] | 66464 | PEI Drivers | CB1 | 2009-11-19 00:00:00 | 2010-03-04 00:00:00 |  | 101007901
8115 | 2 x ds consoles 1 broke | [NAME] | no cables/loans d | Sugar Love | 654641 | PEI Drivers | CB1 | 2010-02-04 00:00:00 | 2010-03-04 00:00:00 |  | 102037201