Can I Count dates without repeating?

  • Thread starter Thread starter bogdan77
  • Start date Start date
B

bogdan77

I am trying to count dates column without repeating every date twice.
For Example:
08/10/05
08/10/05
08/11/05
08/11/05
08/11/05

Answer should be 2.

Is it possible in Excel?

Thank you for your time
 
This is an array formula, committed with Ctrol-Shift-Enter. Assumes you
dates are in cells A1:A10

=SUM(1/COUNTIF(A1:A10,A1:A10))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating interest due on late loan payments 1
Find Period Date? 5
Find within Date Range 4
Need magic Excel formula for Date calculation 2
Delete Row with condition 4
Count occurances within a date... 2
Match offset only if duplicated 3
How to get the max value for each date group 2

Back
Top