Need help with counting criteria within a date range

lisamurzyn

Hi - I am looking to count cells that are "in progress" within a specific month, for example, August. I use this formula but the count doesn't come up correctly. Can you help? Thank you!

=COUNTIFS({Turnaround Plan Range 1}, "In Progress", {Turnaround Plan Range 2}, <=DATE(22, 8, 1) >= DATE(22, 8, 31))

Mike Wilday

Give this a try...

=COUNTIFS({Turnaround Plan Range 1}, "Not Started", {Turnaround Plan Range 2}, AND(>=DATE(2022, 8, 1), <= DATE(2022, 8, 31)))

You could also try this too:

=COUNTIFS({Turnaround Plan Range 1}, "Not Started", {Turnaround Plan Range 2}, >=DATE(2022, 8, 1), {Turnaround Plan Range 2}, <= DATE(2022, 8, 31))

lisamurzyn

Oops - I adjusted my greater than/less than and its still not coming up correctly.

Updated formula -

=COUNTIFS({Turnaround Plan Range 1}, "Not Started", {Turnaround Plan Range 2}, >=DATE(2022, 8, 1) <= DATE(2022, 8, 31))

Mike Wilday

Give this a try...

=COUNTIFS({Turnaround Plan Range 1}, "Not Started", {Turnaround Plan Range 2}, AND(>=DATE(2022, 8, 1), <= DATE(2022, 8, 31)))

You could also try this too:

=COUNTIFS({Turnaround Plan Range 1}, "Not Started", {Turnaround Plan Range 2}, >=DATE(2022, 8, 1), {Turnaround Plan Range 2}, <= DATE(2022, 8, 31))

lisamurzyn

Wonderful! The second one worked perfectly. Thank you so much.