1

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.

migrated from stackoverflow.com May 28 '12 at 6:05

This question came from our site for professional and enthusiast programmers.

3

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

=ArrayFormula(COUNTUNIQUE(TEXT(A1:A30,"yyyymmdd")))

Your Answer

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