Count the number of submissions in a particular year

therapy_mindset

How can I do a Countif Formula that would collect the employee payroll number and count how many times an agent has been absent for ONLY 2023.

One issue I'm having is collecting previous years, such as 2022. I only want it to count as 2023.

Darren Mullen

@therapy_mindset

First, you'll need the COUNTIFS() function to put multiple criteria in.

Second, assuming the "date you were absent" column is a date type, you can extract the year from it with the year() function. You'll need to use the @cell operator in your formula as well. This video might help:

https://youtu.be/KchiWBgsv4A