Is it possible for me to use CountIf or SumIf in Excel for this use case?

I would like to count the number of occurrences of "ACTIVITY_CREATE_USER" (in my Action column) for the last 30 days.

I have an "Action" column and a "ActivityTime.Date" column.

Sample data sheet attached:
SampleValues.xlsx