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

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 : [email protected]

RajKumar 28

Hi Bassam Khalil,

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