Help with a COUNTIFs Formula for a Date Range

N.Derkiss

Hello,

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!

Carson Penticuff

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

Carson Penticuff

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