I am trying to find a formula that will enable to count the number of unique days in a list.
I have a table with one column showing the date with a timestamp. I wanted to count the number of days in this column. Dates with the different timestamp will still be counted as the same day. For example, the result from the data below should be 2 instead of 3.
27/8/2018 12:40:00 PM
28/8/2018 8:50:00 AM
28/8/2018 1:00:00 PM
I have a table with one column showing the date with a timestamp. I wanted to count the number of days in this column. Dates with the different timestamp will still be counted as the same day. For example, the result from the data below should be 2 instead of 3.
27/8/2018 12:40:00 PM
28/8/2018 8:50:00 AM
28/8/2018 1:00:00 PM