COUNTIF the values is lesser than today's date

RajKumar 28

Hi Folks,

I would like to count the names with respective to dates in another column which is lesser than today's date.

I used the below formula:

=COUNTIFS([Projected CM1]:[Projected CM1], <=TODAY(), [CM1]:[CM1], "Flextronics Wuzhong CM")

But it doesn't give the right result, any leads please advise

Thanks!

Raj

Find more posts tagged with

Accepted answers

All comments

Bassam Khalil

Hi @rajcanada

Hope you are fine, please try the following formula:

=COUNTIFS([Projected CM1]:[Projected CM1], @cell <= TODAY(), [CM1]:[CM1],
@cell = "Flextronics Wuzhong CM")

the following screenshot shows the result:

RajKumar 28

Hi Bassam Khalil,

Is that we have to change the date format? It doesnt works for me.

Bassam Khalil

@rajcanada

No need to change the date format, but your date column must be date type.

if you like me to fix the formula directly on your sheet please share me as an admin on a sample copy of your sheet and i will Create the exact formula for you then you can copy it to your original sheet.

My Email for sharing : Bassam.k@mobilproject.it

RajKumar 28

Hi Bassam Khalil,

Thanks for your help, now i have the column to date format & it works now.

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.