1

First thing to have in mind is that Google Sheets (as well as other spreadsheet apps) use serial numbers to handle dates, so when a value looks like 8/15/2019 (if it's handled as date and not as text) Google Sheets internally handle this value as 43692. Recarding COUNTIF, this function requires two arguments and if you will use a comparison operator like &...


Only top voted, non community-wiki answers of a minimum length are eligible