Counting Number of Date Instances

Hello,

I'm trying to create a formula to count the number of instances of a particular date - but I can't get a response out of the forumla - it either comes back as unparseable, or with a 0 count (even though that's the wrong count).

I've tried a few variations:

=COUNTIF(DATE:DATE,06/10/2020)

=COUNTIF(DATE:DATE,"06/10/2020")

=COUNTIF(DATE:DATE,ISDATE(@cell))

None of these seem to work... I'm hoping that someone can help me correct my formula or my formula syntax.

Thanks!

Find more posts tagged with

Formulas

Accepted answers

Chris Mondeau

Hi @Keith Dickson!

There's a couple of ways to do it; basically the countifs is looking for the date value, so you need to format the text as a date value. Here's a couple of options:

The Cell Reference formula uses a column/target cell to set the dates, then counts all instances in the range. (You could also use a sheet summary value of you don't want to clutter your sheet)

If you want to hard code the date, then you can use the DATE() function to format your string as a date to work with the countif().

Hopefully this helps!

All comments

Chris Mondeau

Hi @Keith Dickson!

There's a couple of ways to do it; basically the countifs is looking for the date value, so you need to format the text as a date value. Here's a couple of options:

The Cell Reference formula uses a column/target cell to set the dates, then counts all instances in the range. (You could also use a sheet summary value of you don't want to clutter your sheet)

If you want to hard code the date, then you can use the DATE() function to format your string as a date to work with the countif().

Hopefully this helps!

Keith Dickson

@cmondo - thanks for this the date reference worked perfectly!

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.