Date/Time calculations challenge

[Camping5]

I have a spreadsheet that contains a column of date/time. In that column there are several entries for the same date. I am trying to count the number of 'same' days that occured in a month. Any suggestions at all?????

 

[shg]

Welcome to the board.

So if 2/15 appeared four times and 2/16 appeared three times, is the answer two or seven?

 

[Camping5]

Thank you shg and yes. I need to count only the single occurances of that date.

 

[shg]

Does "yes" mean the answer is two or seven?

 

[Camping5]

Sorry shg. Yes it means I only want to count it as 2. Very sorry.

 

[shg]

If the values are just dates (no times),

=SUMPRODUCT(--(FREQUENCY(A1:A10, A1:A10)>1))

 

[Camping5]

thank you so much shg! The dates are in a date/time format, but I will work with it. Thank you again so very much!!!!

 

[shg]

You're welcome, good luck.

 

[Camping5]

thank you again

 

[DaGoose]

SHG
I learn from reading the problems from other people and try to figure out what was done. If they had wanted all the dates to be counted 3 2/15 and 2 2/16 would count as 5. Would they have used the "COUNTIF" function?

Trying to learn this better so i dont have to bother you folks. VBA is my next adventure. (oh Boy).