Counting rows from a certain date

Victoria Ganuelas

Trying to create a formula to count rows that are from certain date onward (ie. 11/30/2020)

Heather Duff

Hi @Victoria Ganuelas

Do you already have a date column? If so, try this:

=COUNTIF([date column]:[date column], >=DATE(2020, 11, 30))

If it's a cross-sheet formula, you'll want to use something like this, where {date} is the named reference for your date column in the source sheet:

=COUNTIF({date}, @cell >=DATE(2020, 11, 30))

Let me know if this works for you!

Best,

Heather