Pivot Table Sub Total Count Unique Dates

  • Thread starter Thread starter MFM
  • Start date Start date
M

MFM

When I roll up a data set which includes dates the count sub total add every
occurance of the date. I would like to count how many days.
 
Hi,

Your title doesn't agree with your question? Are you trying to count the
number of different dates, but in the question you ask to count how many
days? not dates?

In the pivot table there is no Count Distinct function, but you could put a
formula in the spreadsheet the counts all the dates in the Date field, for
example

=COUNT(B10:B100)

Cheers,
Shane
 
Thanks for your comments.

I was looking for "dates" which as you stated there is no distincet within
pivot tables.
 
Back
Top