countifs only works to certain date

So I am counting different audits, however, it only counts to a certain date/cell. =COUNTIFS(Table1[Date], ">=" & '15.1 New Audit Log.xlsx'!NOV22S,Table1[Date],"<=" & '15.1 New Audit Log.xlsx'!NOV22...