How to count how many are in the last 7 days

COUNTIF is intended to be used when you want to count cells that meet a single criterion. In your case, you are attempting to match two criteria. For this use case, you will want to use COUNTIFS.

=COUNTIFS([Avature Application]:[Avature Application], @cell <= TODAY(), [Avature Application]:[Avature Application], @cell > TODAY(-7))

I didn't set up a test sheet to test this, but it may give you what you are looking for.

=COUNTIFS([Fleet:Fleet], CONTAINS("A220", @cell), [Date of CJO]:[Date of CJO], YEAR(@cell) = YEAR(TODAY())

CONTAINS will find cells that have "A220" anywhere within. From your screenshot, it appears other text could possibly appear in a cell with A220, so this should account for that. Comparing the year of the CJO and TODAY means that you will not need to worry about how many days you are into the year, or even which year it is. When the calendar clicks over to 2024, it will begin looking for 2024 hirings.

For the interviews formula, just replace that column in the above formula. Let me know if this doesn't work for you.

Oops.... had a typo with some square brackets.

=COUNTIFS([Fleet]:[Fleet], CONTAINS("A220", @cell), [Date of CJO]:[Date of CJO], YEAR(@cell) = YEAR(TODAY())

=COUNTIFS([Fleet]:[Fleet], CONTAINS("A220", @cell), [Date of CJO]:[Date of CJO], IFERROR(YEAR(@cell), 0) = YEAR(TODAY())

I suspect one or more of the dates is not formatted correctly, or maybe you have a blank date cell. The IFERROR will allow the formula to continue anyway if that is the issue.