Countifs with dates

Heather Staples

I am trying to create a formula that counts the number of open reqs at the end of a month. The fields are in another sheet (call it Sheet) Fields would be req approval date, and offer acceptance date. I have helper fields created, but not using. I have tried, but think the blanks the offer acceptance date are causing me issue. I tried to put a future date, but the formula is not working.

Basically req must be approved by the end of the month, without an acceptance date that is less is greater than the end of the month as i want all reqs open end of month. I tried:

Countifs{Sheet Approval Date}, <DATE(2022,01,31), {Sheet Acceptance Date},

Paul Newcome

Are you able to provide a screenshot for reference?