r/googlesheets•
Mistiggan

date comparison greater than or equal to in Countif formula doesn't include dates equal to & multi-year comparison

Unsolved

Greater Than or Equal to
I have this set of dates:

A2:A4 [01/04/2023,01/10/2023,01/11/2023]

I create a formula using countif looking for how many values are greater than or equal to A3 expecting a return value of 2:
= COUNTIF(A2:A4, ">="&A3&")")
Actual return value = 1

notes:
in practice with this case, I could just use greater than the date prior although I'm wondering if I've done something wrong to cause "greater than or equal to" to not function

Multi-Year Comparison
If I take the same dates and update the last one to be the year after:
A2:A4 [01/04/2023,01/10/2023,01/11/2024]

I create a formula using countif looking for how many values are greater than or equal to A3 expecting a return value of 2:
= COUNTIF(A2:A4, ">="&A3&")")
Actual return value = 0

notes:
I found that removing the appended &")" does end up counting the final date although that section was recommended to me when doing multiple comparisons for ranges when I submitted a ticket

If I'm not using something I should be using to make these work correctly or If I'm just way off base please let me know any help would be appreciated

Posted Nov 6, 2023, 5:32 PM UTC

113
Loading comments…