How to count rows created in a specific year

jmo

Hi team - I have a sheet that has a date field called Issue Status Date. How do I do a count of rows that have 2019, 2020 and 2021 in the date field?

So I need 3 separate formulas for counts by year but if I have 1 I can modify for the other years.

Appreciate any suggestions.

Thanks,

Jeff

Kelly Moore

Hey @jmoser

Try this

=COUNTIFS([Issue Status Date]:[Issue Status Date], ISDATE(@cell), [Issue Status Date]:[Issue Status Date], YEAR(@cell)=2019)

This will only look for valid dates. Change the date for your other years.

cheers

Kelly Moore

Hey @jmoser

Try this

=COUNTIFS([Issue Status Date]:[Issue Status Date], ISDATE(@cell), [Issue Status Date]:[Issue Status Date], YEAR(@cell)=2019)

This will only look for valid dates. Change the date for your other years.

cheers

jmo

That's the stuff @KDM !!!!

Appreciate the rapid response.