title: How do I count a number of different dates in the same column?
body: <p>I'm currently working on a project for a business in which I have to display how much we make per hour and per day (i'm using pivot tables):
  My first column is &quot;Dates&quot;
  The second one is &quot;Hours&quot;
  The third one is &quot;Turnover&quot;</p>
  <p>The idea is that the hours column is as followed:</p>
  <pre><code>&lt;8:00
  
  8:00-9:00
  
  9:00-10:00
  
  ...
  
  17:00-18:00
  
  18:00&lt;
  </code></pre>
  <p>Which means that my dates column include 13 times the same date for each day (I want it to be count as 1 and not 13)</p>
  <p>The idea is to display, the sum of days opened per month and per year (in order to display a pivot table graph)</p>
  <p>You'll find enclosed a screenshot that shows the sheet, column 2 and 3 are not part of the problem.</p>
  <p><a href="https://i.stack.imgur.com/7wdkq.png" rel="nofollow noreferrer">Excel Sheet example</a></p>