I'm trying to create a spreadsheet that sums expenses and returns them based on week of month.

Table 1 has 4 columns (date, description, amount, sumbyweek_rows) table 2 has multiple columns (key for "sumbyweek_rows," summed amount from "amount," and several cells that check data against "description" to know whether to sum it or not)

On table 2 I'm struggling with sumifs. I'd like my summed amount to sum if there is any cell with matching data from the amount cell on table 1, it uses the description cell as a key. But I'd like a second check to see if the date column is week 1, 2, 3, or 4 of month.

I can do it without the date by doing this:

SUM(ARRAYFORMULA(SUMIF(CurrentMonth!$BC$2:$BC$1000, {C6:AC6},CurrentMonth!$BD$2:$BD$1000)))

But I'm stuck at trying to convert it to SUMIFS including date checks. I've tried testing 3 dating methods and none of them work, but I don't see why:

SUMIFS(CurrentMonth!$BD$2:$BD$1000,CurrentMonth!$BA$2:$BA$1000,">=""/01/",CurrentMonth!$BA$2:$BA$1000,"<=""/07/")

SUMIFS(CurrentMonth!$BD$2:$BD$1000,CurrentMonth!$BA$2:$BA$1000,">="&date(,,01),CurrentMonth!$BA$2:$BA$1000,"<="&date(,,07))

SUMIFS(CurrentMonth!$BD$2:$BD$1000,1,WEEKNUM(BA2:BA1001)-WEEKNUM(EOMONTH(BA2:BA1001,-1)+1)