COUNTIF Date is past a specific date

jmo

Hey team - I have an auto generated "Submitted" column that automatically creates the date that the row items was submitted/created.

I'm an trying to create a sheet summary formula to count the number of rows that were created after 04/19/21.

I tried the following and it returns 0:

• =COUNTIFS(Submitted:Submitted, @cell > 4 / 19 / 21)
• =COUNTIF(Submitted:Submitted, @cell > 4 / 19 / 21)

There are at least 20 rows that were created after after 04/19/21.

Any ideas what I'm missing?

Paul Newcome

Try this...

=COUNTIFS(Submitted:Submitted, DATEONLY(@cell) > DATE(2021, 04, 19))

jmo

Hi @Paul Newcome - I get an INVALID DATA TYPE when I use that formula.

Paul Newcome

Ok. Try this then...

=COUNTIFS(Submitted:Submitted, IFERROR(DATEONLY(@cell), DATE(2021, 04, 18)) > DATE(2021, 04, 19))

Edited to correct a missing parenthesis.

jmo

Same thing @Paul Newcome - INVALID DATA TYPE when I use =COUNTIFS(Submitted:Submitted, IFERROR(DATEONLY(@cell), DATE(2021, 04, 18)) > DATE(2021, 04, 19))

Paul Newcome

That's odd.

Remove the formula completely.

Log out.

Clear your browser's cookies and cache.

Log back in.

Manually key the formula.

Lets see if that helps any...

jmo

Well that appeared to work, @Paul Newcome !

Thanks for hanging in there with me.

Paul Newcome

Great. On rare occasion I have found that there is (for whatever reason) latent data that hangs around on the back-end. If you know for a fact that a formula should be working but it isn't, I suggest taking those steps.

Typically when I have run into this issue is when I am using dates in a COUNTIFS (just a heads up).