Countif Formula to validate the old dates with in range

RajKumar 28

Hi All,

I would like to count the column with dates specified with the range

Example below : I need counts for Today Minus last 10 days counts

In excel i can use this formula to validate and give right values

=COUNTIF(A2:A15,"<"&TODAY()-7)

I need the same formula for smart sheet

Find more posts tagged with

Accepted answers

All comments

Kelly Moore

Hey @rajcanada

Try this

=COUNTIFS([Date Released.1]:[Date Released.1], AND(@cell > TODAY(-10), @cell <= TODAY()))

This says count the dates in the Date Released.1 column where the date is greater than 10 days ago and is equal to or less than today's date. This should give you your window of past ten days.

Will this work for you?

Kelly

If interested, here are some of the concepts I used

https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell

https://help.smartsheet.com/function/countifs

RajKumar 28

Hi Kelly Moore,

Thanks it is really appreciated , it works very well

Regards

Raj

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.