COUNTIF the values is lesser than today's date
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
Answers
-
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:
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi Bassam Khalil,
Is that we have to change the date format? It doesnt works for me.
-
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
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi Bassam Khalil,
Thanks for your help, now i have the column to date format & it works now.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!