Spreadsheet: 872067d1718429913-assistance-needed-with-formulas-dealing-with-dates-and-categories-categorys_data_example_june-24-wip-aligw
Sheet: Sheet1

Amt Spent  By Categories |  |  |  |  |  | SELECT  YEAR | years | months | Categories Choices |  | DATABASE ENTRYS
Previous Year |  |  | Current Year |  |  | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 | Jan | Utilities |  | Date | AMOUNT | CATEGORIES
Per-Year |  |  | Current Year |  |  |  | 2025-01-01 00:00:00 | Feb | Telephone |  | 2024-04-03 00:00:00 | 33.09 | Food
 |  |  |  |  |  | SELECT MONTH | 2026-01-01 00:00:00 | Mar | Fuel |  | 2024-04-05 00:00:00 | 16.92 | Food
Category : |  |  | Select Category : | Food |  | Apr | 2027-01-01 00:00:00 | Apr | Food |  | 2024-04-05 00:00:00 | 31.4 | Food
Year : |  |  | Year : |  |  |  | 2028-01-01 00:00:00 | May |  |  | 2024-04-05 00:00:00 | 3.69 | Food
Month : |  |  | Month : |  |  |  | 2029-01-01 00:00:00 | Jun |  |  | 2024-04-05 00:00:00 | 4.75 | Food
Amount  : |  |  | Amount  : |  |  | <--What wrong here? I think it's correct. | 2030-01-01 00:00:00 | Jul |  |  | 2024-04-07 00:00:00 | 46.42 | Food
Net Monthly Income: |  |  | Net Monthly Income: |  |  |  | 2031-01-01 00:00:00 | Aug |  |  | 2024-04-09 00:00:00 | 24.13 | Food
 |  |  |  |  |  |  | 2032-01-01 00:00:00 | Sep |  |  | 2024-04-10 00:00:00 | 2.99 | Food
Per-Month |  |  | Current Month |  |  |  | 2033-01-01 00:00:00 | Oct |  |  | 2024-04-12 00:00:00 | 33.68 | Food
 |  |  |  |  |  |  | 2034-01-01 00:00:00 | Nov |  |  | 2024-04-13 00:00:00 | 48.09 | Food
Category : |  |  | Category : |  |  |  | 2035-01-01 00:00:00 | Dec |  |  | 2024-04-17 00:00:00 | 57.35 | Food
Amount  : |  |  | Amount  : |  |  | <--What wrong here? I think it's now correct - you had not included the month. | 2037-01-01 00:00:00 |  |  |  | 2024-04-19 00:00:00 | 46.93 | Food
Net Monthly Income: |  |  | Net Monthly Income: |  |  |  | 2038-01-01 00:00:00 |  |  |  | 2024-04-22 00:00:00 | 49.86 | Food
 |  |  |  |  |  |  | 2039-01-01 00:00:00 |  |  |  | 2024-04-25 00:00:00 | 57.65 | Food
Monthly Average |  |  | Current Monthly Average |  |  |  | 2040-01-01 00:00:00 |  |  |  | 2024-04-26 00:00:00 | 12.33 | Food | APR TOTAL
 |  |  |  |  |  |  | 2041-01-01 00:00:00
Category : |  |  | Category : |  |  |  | 2042-01-01 00:00:00 |  |  |  | 2024-05-01 00:00:00 | 3.96 | Food
Amount  : | 0 |  | Amount  : | 0 |  | <--What wrong here? No formula! What VALUE are you expecting here? | 2044-01-01 00:00:00 |  |  |  | 2024-05-01 00:00:00 | 101.16 | Food
Net Monthly Income: |  |  | Net Monthly Income: |  |  |  | 2045-01-01 00:00:00 |  |  |  | 2024-05-08 00:00:00 | 85.94 | Food
 |  |  |  |  |  |  | 2046-01-01 00:00:00 |  |  |  | 2024-05-10 00:00:00 | 16.75 | Food
 | ^^^--What VALUES are you expectiung here and how should they differ from the values in column E? What does 'per-year' mean? |  |  |  |  |  | 2047-01-01 00:00:00 |  |  |  | 2024-05-11 00:00:00 | 72.86 | Food
 |  |  |  |  |  |  | 2048-01-01 00:00:00 |  |  |  | 2024-05-16 00:00:00 | 10 | Food
 |  |  |  |  |  |  | 2049-01-01 00:00:00 |  |  |  | 2024-05-16 00:00:00 | 102.83 | Food
 |  |  |  |  |  |  | 2050-01-01 00:00:00 |  |  |  | 2024-05-24 00:00:00 | 57.99 | Food
 |  |  |  |  |  |  |  |  |  |  | 2024-05-24 00:00:00 | 73.09 | Food
 |  |  |  |  |  |  |  |  |  |  | 2024-05-27 00:00:00 | 72.86 | Food
 |  |  |  |  |  |  |  |  |  |  | 2024-05-30 00:00:00 | 24.85 | Food | MAY TOTAL
 |  |  |  |  |  |  |  |  |  |  | 2024-06-01 00:00:00 | 39.99 | Food
 |  |  |  |  |  |  |  |  |  |  | 2024-06-05 00:00:00 | 95.01 | Food
 |  |  |  |  |  |  |  |  |  |  | 2024-06-06 00:00:00 | 31.79 | Food
 |  |  |  |  |  |  |  |  |  |  | 2024-06-06 00:00:00 | 21.33 | Food | JUN TOTAL
 |  |  |  |  |  |  |  |  |  |  | 2024-01-05 00:00:00 | 44.57 | Fuel
 |  |  |  |  |  |  |  |  |  |  | 2024-01-13 00:00:00 | 76.24 | Fuel
 |  |  |  |  |  |  |  |  |  |  | 2024-01-18 00:00:00 | 39.74 | Fuel | JAN TOTAL
 |  |  |  |  |  |  |  |  |  |  | 2024-02-01 00:00:00 | 36.08 | Fuel
 |  |  |  |  |  |  |  |  |  |  | 2024-02-10 00:00:00 | 39.08 | Fuel
 |  |  |  |  |  |  |  |  |  |  | 2024-02-16 00:00:00 | 37.45 | Fuel
 |  |  |  |  |  |  |  |  |  |  | 2024-02-16 00:00:00 | 43.16 | Fuel
 |  |  |  |  |  |  |  |  |  |  | 2024-02-25 00:00:00 | 45.38 | Fuel | FEB TOTAL
 |  |  |  |  |  |  |  |  |  |  | 2024-03-22 00:00:00 | 50.45 | Fuel | MAR TOTAL
 |  |  |  |  |  |  |  |  |  |  | 2024-04-03 00:00:00 | 39.39 | Fuel
 |  |  |  |  |  |  |  |  |  |  | 2024-04-19 00:00:00 | 50.67 | Fuel
 |  |  |  |  |  |  |  |  |  |  | 2024-04-30 00:00:00 | 51.87 | Fuel | APR TOTAL
 |  |  |  |  |  |  |  |  |  |  | 2024-05-04 00:00:00 | 34.27 | Fuel
 |  |  |  |  |  |  |  |  |  |  | 2024-05-11 00:00:00 | 39.63 | Fuel
 |  |  |  |  |  |  |  |  |  |  | 2024-05-19 00:00:00 | 40.33 | Fuel
 |  |  |  |  |  |  |  |  |  |  | 2024-05-24 00:00:00 | 51.7 | Fuel | MAY TOTAL
 |  |  |  |  |  |  |  |  |  |  | 2024-06-07 00:00:00 | 33.05 | Fuel | JUN TOTAL
 |  |  |  |  |  |  |  |  |  |  | 2024-01-17 00:00:00 | 125.73 | Telephone
 |  |  |  |  |  |  |  |  |  |  | 2024-02-15 00:00:00 | 77.82 | Telephone
 |  |  |  |  |  |  |  |  |  |  | 2024-03-19 00:00:00 | 77.82 | Telephone
 |  |  |  |  |  |  |  |  |  |  | 2024-04-20 00:00:00 | 78.42 | Telephone
 |  |  |  |  |  |  |  |  |  |  | 2024-05-19 00:00:00 | 78.33 | Telephone
 |  |  |  |  |  |  |  |  |  |  | 2024-04-22 00:00:00 | 49.86 | Utilities
 |  |  |  |  |  |  |  |  |  |  | 2024-04-25 00:00:00 | 57.65 | Utilities
 |  |  |  |  |  |  |  |  |  |  | 2024-04-26 00:00:00 | 12.33 | Utilities
 |  |  |  |  |  |  |  |  |  |  | 2024-04-26 00:00:00 | 12.33 | Utilities
 |  |  |  |  |  |  |  |  |  |  | 2024-05-01 00:00:00 | 3.96 | Utilities
 |  |  |  |  |  |  |  |  |  |  | 2024-05-01 00:00:00 | 101.16 | Utilities
 |  |  |  |  |  |  |  |  |  |  | 2024-05-08 00:00:00 | 85.94 | Utilities
 |  |  |  |  |  |  |  |  |  |  | 2024-05-10 00:00:00 | 16.75 | Utilities
 |  |  |  |  |  |  |  |  |  |  | 2024-05-11 00:00:00 | 72.86 | Utilities
 |  |  |  |  |  |  |  |  |  |  | 2024-05-16 00:00:00 | 10 | Utilities
 |  |  |  |  |  |  |  |  |  |  | 2024-05-16 00:00:00 | 102.83 | Utilities