How to count number of days within datetime array

I have a timetable which spans a year. The intervals between the datetimes varies from one minute to ten minutes. I am interested in finding out how many days contain any data at all. I tried using histogram but this returns an empty bin on days in which there was no data collected, and so conflates days where there was data collected but the values were 0, and data where there was no data collected.

numberdays=histogram(timetable.DateTime,'BinMethod','day');

This seems like it should be simple but I am sorry I can't figure it out!

Answer 1

[Kanupriya Singh]

Since your previous attempts are returning you empty data for days that are not in your datetime array, you could calculate the number of days that have any data by using this function-

nnz(x)

This will return you the number of non-zero elements in the array.

[Louise Wilson]

Thanks Kanupriya-I have actually since done this before you replied and it's the only method I have found to work!

[Louise Wilson]

[Tally,~,bin]=histcounts(tt,'BinMethod','day'); 
days=nnz(Tally);

Answer 2

[madhan ravi]

Use retime() with 'daily' 'count' .

[Louise Wilson]

Thanks for your response Madhan. I tried this:

countdays=retime(Kawau_counts,'daily','count');

but it does the same as my attempt above. It lists all days between the first datetime and last datetime in my timetable, and so creates rows for datetimes that never existed in my timetable in the first place.