COUNTIFS Formula - Date Range and Criteria

ChristineFett

I am trying to figure out a formula to count the number of times a specific item is on a sheet between a date range and cannot seem to get the correct answer or keep getting an error.

In an easy example below, I am trying to find a formula that will count the number of times "W" occurs between April 1, 2023 and April 30, 2023. How would I write that out? Any help would be great.

haley brianne

Hi Christine!

I would try the following:

=COUNTIFS(Name, "W", Date, ">="&DATE(2023,4,1), Date, "<="&DATE(2023,4,30))

ChristineFett

That partially worked. I changed "Name" to "Task Bar" and I was good to go. Thanks so much for the help!