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.

Find more posts tagged with

Formulas

Accepted answers

L_123

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

All comments

L_123

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

Kelly Moody

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.