# Need help with counting criteria within a date range

Options

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))

Tags:

• ✭✭✭✭✭✭
Options

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))

• Options

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))

• ✭✭✭✭✭✭
Options

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))

• Options

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!