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.
Best Answer

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
Answers

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
Categories
Check out the Formula Handbook template!