COUNTIF with dates?

Jorge_Gtz

Hi team!

So, I have a date column with the date where a row is created "Created date" in my sheet. I'm trying to find a way how can I count how many rows are created in weekly periods. I have in my metrics sheet 2 columns with the ranges:

I need in column 4 something like a: "Countif ("Ceated date" in between dates in column 2 and 3).

Any ideas?

Michelle Choate 2

Just use a COUNTIFS formula. This is assuming your Created Date is a DATE ONLY column, and not the system generated column with the time information still in it. I use a secondary column with the =DATEONLY([Created Date]@row) formula to have my Created column to use for calculations.

Using Created Date assuming it is a date only column, the formula would be:

=COUNTIFS([Created Date]:[Created Date],>=Column2@row, [Created Date]:[Created Date], <=Column3@row)

Michelle Choate 2

Just use a COUNTIFS formula. This is assuming your Created Date is a DATE ONLY column, and not the system generated column with the time information still in it. I use a secondary column with the =DATEONLY([Created Date]@row) formula to have my Created column to use for calculations.

Using Created Date assuming it is a date only column, the formula would be:

=COUNTIFS([Created Date]:[Created Date],>=Column2@row, [Created Date]:[Created Date], <=Column3@row)

Humashankar

Good insight

Jorge_Gtz

OMG, so simple lol...Thanks for the inputs @Michelle Choate 2 !! this was exactly what I needed.

Regards!