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.

1 Answer 1


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


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.