2

I have a column full of datetime values in a Google Spreadsheet.

I want to get a count of how many unique days there are. As in 8pm and 7pm today would count as 1. Tomorrow at 9pm, 3pm and 4pm would also count as 1.

4

Assuming your dates are in A1:A30, the following array formula worked for me:

=ArrayFormula(COUNTUNIQUE(TEXT(A1:A30,"yyyymmdd")))
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy