Google sheet formula help!

[Bjlangbehn]

Hello,

I am trying to use Google Sheets to create a budget tracker. I got the template from someone else and I'm trying to tweek it to fit my needs. How it is supposed to work is that I use a Google form to submit a response to sheet A and then sheet B has a formula to pull from sheet A to the right place. I believe there is something wrong with the formula that is being used but I don't know how to fix it.

The formula is: =SUMIFS(Expenses!$D$1:$D, Expenses!$B$1:$B, ">="&$A9, Expenses!$B$1:$B, "<"&(EOMONTH($A9, 0)+1), Expenses!$E$1:$E, "="&B$1)

I believe the problem lies within the first Expenses!$B$1:$B. When I highlighted it, it gave the date of 8/22/2020. So, when I input an expense using that date, it will calculate it. However, when I put in any other date, it won't register it. How can I fix this? Here is the link to the sheet I'm working with. Copy of Copy of Expense Tracker - [PUBLIC TEMPLATE]

 

[Bjlangbehn]

I'm realizing my problem is that it won't recognize 2021 dates.