COUNTIFS for a specific text within a yearly date range

Hello everyone,

I am having some issues trying to get my excel to pull data from a different tab to count the total of the "Unsats" within a yearly date range. I have attempted to change it from COUNT IFS to IF to A put receive errors each time. I have also gone through multiple posts and different sites, but the other formulas I have used did not work either. The "Unsats" are in column G and the Date ranges are in column B (formatted as D-MMM-YYYY) where they both start off on the 3rd row. Any help would be appreciated, thank you!

The current formulas I have attempted are:

=COUNTIFS(Inspections!G3:G550,"Unsat", Inspections!B3:B550, ">=1-Jan-2023", Inspections!B3:B550, "<=31-Dec-2023")

=COUNTIFS(Inspections!G3:G550,"Unsat", Inspections!B3:B550,">="&DATE(1-Jan-2023),Inspections!B3:B550,"<="&DATE(31-Dec-2023))