Countifs with Date Range

Desiree de los Reyes

Hi! I have a number of columns with dates and need to count rows within a date range, i.e., products sold between January 1, 2021 and March 31, 2021. How do I write the formula to recognize the date range?

Heather Duff

Hi Desiree,

Try this:

=COUNTIFS(Date:Date, @cell >= DATE(2021, 1, 1), Date:Date, @cell <= DATE(2021, 3, 31))

The dates are listed in (YYYY, M, D) format, so if you want to switch the dates for the range to 4/1 through 6/30, you'd do (2021, 4, 1) and (2021, 6, 30).

Hope this helps! Let me know if it works.

Best,

Heather

Heather Duff

Hi Desiree,

Try this:

=COUNTIFS(Date:Date, @cell >= DATE(2021, 1, 1), Date:Date, @cell <= DATE(2021, 3, 31))

The dates are listed in (YYYY, M, D) format, so if you want to switch the dates for the range to 4/1 through 6/30, you'd do (2021, 4, 1) and (2021, 6, 30).

Hope this helps! Let me know if it works.

Best,

Heather

Desiree de los Reyes

You are awesome, Heather! Thank you so much.

Heather Duff

Happy to help!