How do I use CountIF to count items 30 days or less from Today without counting items in the past?

Jordan1990

I have a CountIF formula set to count the number of cells that have dates 30 days or less from Today's date using the Today function, however it is also counting dates that are in the past. I only want to count the number of dates that are 30 days or less in the future.

Any way I can exclude past dates?

Here is what I am using for a formula:

=COUNTIF([Date Needed By]:[Date Needed By], <TODAY(+30))

Find more posts tagged with

Formulas

Accepted answers

Jeff Reisman

Try using COUNTIFS instead. You can specify dates less than or equal to 30 days in the future, and dates greater than or equal to today.

=COUNTIFS([Date Needed By]:[Date Needed By], <=TODAY(+30), [Date Needed By]:[Date Needed By], >=TODAY(0))

All comments

Jeff Reisman

Try using COUNTIFS instead. You can specify dates less than or equal to 30 days in the future, and dates greater than or equal to today.

=COUNTIFS([Date Needed By]:[Date Needed By], <=TODAY(+30), [Date Needed By]:[Date Needed By], >=TODAY(0))

Leibel S

@Jordan1990

Seems like you are looking for the below:

=COUNTIF([Date Needed By]:[Date Needed By], AND(@cell > TODAY(), @cell < TODAY(30)))

Jordan1990

Thank you, both of these solved my issue!!

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.