Help with a COUNTIFs Formula for a Date Range


I need a formula to count the number of times any date within July 2023 occurs within a set range of a column. This is what I have so far:

=COUNTIFS([Date in Job]2:[Date in Job]76, >=DATE(2023, 07, 01),<=DATE(2023. 07, 31))

Thank you!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!