COUNTIFS help - getting UNPARSEABLE

System

This discussion was created from comments split from: Count of cells in a date range.

Sharon Castiglia

Tried this formula:

=COUNTIFS([Install Schedule];[Install Schedule], >DATE(2018, 12, 30),[Install Schedule]:[Install Schedule], <DATE(2019, 01, 07), [Install Complete]:[Install Complete], ="Yes")

and I am getting #UNPARSEABLE .

I am at a loss.

Please and Thank you

Sharon C.

Paul Newcome

Your first range has a semicolon as a separator between the column names instead of a colon. Try this instead...

=COUNTIFS([Install Schedule]:[Install Schedule], >DATE(2018, 12, 30),[Install Schedule]:[Install Schedule], <DATE(2019, 01, 07), [Install Complete]:[Install Complete], ="Yes")