CountIF Formula for Dates in the Past

I am trying to amend a current formula I am using to track enrollment. Currently, I have this formula:

=COUNTIF([Date of Injection]1:[Date of Injection]100, ISDATE(@cell)) which counts the amount of cells that have a date so my team can track how many animals we have enrolled in a certain project.

I want to change this to count the number of cells with a date but only if that date is in the past so my sheet summary data accurately reflects current enrollment.

Is this possible?

Find more posts tagged with

Formulas

Accepted answers

Matt Johnson

Hi @MirandaLang

I think this formula should work:

=COUNTIF([Date of Injection]1:[Date of Injection]100,<TODAY())

I would probably adjust the range so it reads like this though: =COUNTIF([Date of Injection]:[Date of Injection],<TODAY()). That way it picks up the whole column and will be maintenance free if you have over 100 animals.

I hope that helps.

Matt

All comments

Matt Johnson

Hi @MirandaLang

I think this formula should work:

=COUNTIF([Date of Injection]1:[Date of Injection]100,<TODAY())

I hope that helps.

Matt

MirandaLang

Thank you so much! This worked :)

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.