New answers tagged


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 &...

Top 50 recent answers are included