Count entries based on dates.

Cristian

Hello

I have a sheet which contains engagements request the last 4 years. This sheet has a Created Date column. How can I track engagement request based on year the request came in? In addition, how can I track that based on month as well?

Thanks for you help

Paul Newcome

If all you need is a count, it would look something along the lines of:

=COUNTIFS({Date Range}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2024))

Humashankar

Great Insight