Countifs for records older then set date.

Hello

I am looking for help on the countifs formula.

I have a sheet with many entries. I need to find entriers added before a specific date. NOTE: I don't have a date column in my sheet.

Here's the formula I am trying to use but its not working:

=COUNTIFS({NESV Tracker Range 1}, "EPC", <=DATE(2023, 1, 6))

Any help would be appreciated.

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hi @Cristian

In order for a formula to evaluate a date range, there would need to be a date column in the source sheet. In your instance, I would recommend adding (and then hiding) the system Created Date column to your sheet. This will automatically back-fill information into your current rows, adding a date to each row for when it was created.

Then you can use that as the Range in your COUNTIFS to evaluate for your date:

=COUNTIFS({NESV Tracker Range 1}, "EPC", {Created Date Column}, <=DATE(2023, 1, 6))

Cheers,

Genevieve

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.