# Countif with Min and Max Date Range

So the excel formula I'm trying to replicate is below. Basically, I'm trying to count every cell that has a date between Jan. 1, 2021 and Jan. 31, 2021. The outcome should only be one number.

=COUNTIFS(Sheet1!N:N,">=1/1/2021",Sheet1!N:N,"<=1/31/2021")

But I've tried so many things. I can't figure out what try next. I've been combing through Smartsheet Community for an hour. All I've figured out is that there's a structure for dates and that there's irrelevant functions for minumum and maximum out of a range. To confirm, I don't want to know what's the minimum date or maximum date in a range. I want to know how many times a column has a January 2021 date.

Thanks in advance if you can help! I'm super eager to learn.

Tags:

• There's a handful of ways you can do this. 2 basic examples are below:

=COUNTIFS(Sheet1!N:N,and(@cell <= date(2021,1,31),@cell >= date(2021,1,1

=COUNTIFS(Sheet1!N:N,and(month(@cell) = 1, year(@cell) = 2021

• There's a handful of ways you can do this. 2 basic examples are below:

=COUNTIFS(Sheet1!N:N,and(@cell <= date(2021,1,31),@cell >= date(2021,1,1

=COUNTIFS(Sheet1!N:N,and(month(@cell) = 1, year(@cell) = 2021

• Thanks so much! I can't get the second one to work, but the first one does! This is amazing! You saved me a bunch of time.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!