I am trying to count a topic by year

Adina.J_Bradshaw

I am trying to count a certain topic by a certain date range. I cant figure out what is wrong with my formula

=COUNTIFS({OSH Tracker Rules Range 1},"Open",IF({OSH Tracker Rules Range 2},DATE[23, 01, 01] DATE [23, 12, 31])

Anson Cheung

Hi Adina, I notice there are a number of issues in your date range formula. In short, your formula should be similar to the following after rectification.

=COUNTIFS({OSH Tracker Rules Range 1},"Open", {OSH Tracker Rules Range 2}, >=DATE(2023, 1, 1), {OSH Tracker Rules Range 2}, <=DATE(2023, 12, 31))

--Anson

Anson Cheung

Hi Adina, I notice there are a number of issues in your date range formula. In short, your formula should be similar to the following after rectification.

=COUNTIFS({OSH Tracker Rules Range 1},"Open", {OSH Tracker Rules Range 2}, >=DATE(2023, 1, 1), {OSH Tracker Rules Range 2}, <=DATE(2023, 12, 31))

--Anson

Adina.J_Bradshaw

This is amazing! Thank you. I knew there was a < and someplace but i was having a hard time getting it in there correctly.