Spreadsheet: 859384d1707783538-lookup-from-a-date-to-a-date-range-date-lookup
Sheet: L2005M Travel

 |  |  |  |  |  |  |  |  |  |  |  | 67.0 cents per mile (January 1, 2024–December 31, 2024)
Total | DATA_TYPE | FY_AP |  |  |  |  |  |  |  |  |  | 65.5 cents per mile (February 1, 2023–December 31, 2023)
 | EXPENSE | EXPENSE | EXPENSE | EXPENSE | EXPENSE | EXPENSE | EXPENSE Total |  |  |  |  | 62.5 cents per mile (July 1, 2022–January 31, 2023) | From date | Rate
SERVICE_DATE | 2024_01 | 2024_02 | 2024_03 | 2024_04 | 2024_05 | 2024_06 |  | Rate |  |  |  | 58.5 cents per mile (January 1, 2022–June 30,2022) | 2019-01-01 00:00:00 | 57.5
2021-09-21 00:00:00 | 0 | 32.97 | 0 | 0 | 0 | 0 | 32.97 |  |  |  |  | 56.0 cents per mile (May 31, 2021-December 31,2021) | 2020-01-01 00:00:00 | 56
2023-01-08 00:00:00 | 0 | 0 | 0 | 0 | 336.97 | 0 | 336.97 |  |  |  |  | 54.5 cents per mile (Sep 1–May 31, 2021) DFPS only | 2020-09-01 00:00:00 | 54.5
2023-01-10 00:00:00 | 0 | 0 | 0 | 0 | 0 | 600.27 | 600.27 |  |  |  |  | 56.0 cents per mile (Jan 1–Aug 31, 2020) | 2021-05-31 00:00:00 | 56
2023-01-13 00:00:00 | 0 | 0 | 0 | 0 | 185.37 | 0 | 185.37 |  |  |  |  | 57.5 cents per mile (Jan. 1–Dec 31, 2020) | 2022-01-01 00:00:00 | 58.5
2023-01-23 00:00:00 | 0 | 0 | 0 | 0 | 0 | 138.8 | 138.8 |  |  |  |  |  | 2022-07-01 00:00:00 | 62.5
2023-07-17 00:00:00 | 0 | 42.29 | 0 | 0 | 0 | 0 | 42.29 |  |  |  |  |  | 2023-02-01 00:00:00 | 65.5
2024-01-26 00:00:00 | 0 | 0 | 0 | 0 | 889.6899999999999 | 474.26 | 1363.95 |  |  |  |  |  | 2024-01-01 00:00:00 | 67
2024-01-26 00:00:00 | 0 | 0 | 0 | 0 | 0 | 161.64 | 161.64
2024-01-26 00:00:00 | 0 | 0 | 0 | 0 | 1701.01 | 236.17 | 1937.18
2024-01-26 00:00:00 | 0 | 0 | 0 | 0 | 2223.86 | 6687.660000000001 | 8911.52
2024-01-26 00:00:00 | 0 | 0 | 0 | 0 | 856.5 | 0 | 856.5
2024-01-26 00:00:00 | 0 | 0 | 0 | 0 | 905.97 | 0 | 905.97
2024-01-26 00:00:00 | 0 | 0 | 0 | 0 | 1215.63 | 0 | 1215.63
2024-01-26 00:00:00 | 0 | 0 | 0 | 0 | 303.12 | 0 | 303.12
2024-01-26 00:00:00 | 0 | 0 | 0 | 0 | 405.91 | 372.26 | 778.1700000000001
2024-01-26 00:00:00 | 0 | 0 | 0 | 0 | 501.34 | 0 | 501.34
2024-01-27 00:00:00 | 0 | 0 | 0 | 0 | 0 | 375.05 | 375.05
2024-01-27 00:00:00 | 0 | 0 | 0 | 0 | 0 | 615.89 | 615.89
2024-01-27 00:00:00 | 0 | 0 | 0 | 0 | 0 | 1039.26 | 1039.26
2024-01-27 00:00:00 | 0 | 0 | 0 | 0 | 0 | 70.2 | 70.2
2024-01-28 00:00:00 | 0 | 0 | 0 | 0 | 0 | 424.35 | 424.35
2024-01-28 00:00:00 | 0 | 0 | 0 | 0 | 705.3399999999999 | 1443.1 | 2148.44
2024-01-29 00:00:00 | 0 | 0 | 0 | 0 | 0 | 393.15 | 393.15
2024-01-29 00:00:00 | 0 | 0 | 0 | 0 | 0 | 1016.37 | 1016.37
2024-01-29 00:00:00 | 0 | 0 | 0 | 0 | 0 | 621.4399999999999 | 621.4399999999999
2024-01-29 00:00:00 | 0 | 0 | 0 | 0 | 1263.17 | 3176.37 | 4439.540000000001
2024-01-29 00:00:00 | 0 | 0 | 0 | 0 | 410.72 | 1127.82 | 1538.54
2024-01-29 00:00:00 | 0 | 0 | 0 | 0 | 0 | 800.89 | 800.89
2024-01-29 00:00:00 | 0 | 0 | 0 | 0 | 0 | 1225.86 | 1225.86
2024-01-29 00:00:00 | 0 | 0 | 0 | 0 | 0 | 558.65 | 558.65
2024-01-29 00:00:00 | 0 | 0 | 0 | 0 | 0 | 1778.9 | 1778.9
2024-01-29 00:00:00 | 0 | 0 | 0 | 0 | 0 | 492.43 | 492.43
2024-01-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 56.31 | 56.31
2024-01-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 2458.11 | 2458.11
2024-01-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 1355.14 | 1355.14
2024-01-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 2112.02 | 2112.02
2024-01-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 181.89 | 181.89
2024-01-30 00:00:00 | 0 | 0 | 0 | 0 | 1580.45 | 12649.04 | 14229.49
2024-01-30 00:00:00 | 0 | 0 | 0 | 0 | 208.97 | 342.88 | 551.85
2024-01-30 00:00:00 | 0 | 0 | 0 | 0 | 784.78 | 0 | 784.78
2024-01-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 1.07 | 1.07
2024-01-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 212.89 | 212.89
2024-01-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 922.31 | 922.31
2024-01-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 3067.9 | 3067.9
2024-01-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 273.67 | 273.67
2024-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 118.94 | 118.94
2024-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 973.16 | 973.16
2024-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 26677.87000000001 | 26677.87000000001
2024-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 10543.5 | 10543.5
2024-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 109.65 | 109.65
2024-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 24053.06 | 24053.06
2024-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 14714.6 | 14714.6
2024-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 1810.05 | 1810.05
2024-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 2441.79 | 2441.79
2024-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 59.98 | 59.98
2024-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 509.33 | 509.33
2024-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 672.35 | 672.35
2024-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 68.78 | 68.78
2024-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 373.35 | 373.35
2024-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 3547.37 | 3547.37
2024-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 1663.83 | 1663.83
2024-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 2.17 | 2.17
2024-02-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 1892.74 | 1892.74
2024-02-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 32.66 | 32.66
2024-02-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 512.57 | 512.57
2024-02-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 327.98 | 327.98
2024-02-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 538.59 | 538.59
2024-02-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 534.87 | 534.87
2024-02-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 1784.07 | 1784.07
2024-02-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 349.0599999999999 | 349.0599999999999
2024-02-02 00:00:00 | 0 | 0 | 0 | 0 | 0 | 1345.62 | 1345.62
2024-02-03 00:00:00 | 0 | 0 | 0 | 0 | 0 | 452.79 | 452.79
2024-02-05 00:00:00 | 0 | 0 | 0 | 0 | 0 | 280.54 | 280.54
2024-10-23 00:00:00 | 0 | 0 | 0 | 0 | 0 | 16.26 | 16.26