4

I have two columns that I am using, one is a checkbox column, the other is a date column. I want to know, of those that have a checkbox checked in one column, how many of them come after the date 07/01/2019 in the other column. Does anyone know the syntax for that? The column names. The checkbox column is "Approved", the date column is "Date Received". Thanks!!

Functionality

Comments

Try this: 

=COUNTIFS([Date Received]:[Date Received], >=DATE(2019, 7, 1), Approved:Approved, 1)

Do be aware that the >= sign will take into account 7/1. Remove the equal sign if you truly want greater than 7/1/2019.

I'm glad we could help you out! laugh