Count number of days from dates

[nparsons75]

Hi,

I have a pivot table with changes on the use of a slicer. I need to have a count of the number of days in the list. In the example, the count should be 14. I have tried adding a new calculated field but cant get the answer i need, 14. Any help appreciated.

Row Labels
03/08/2021
04/08/2021
05/08/2021
09/08/2021
11/08/2021
12/08/2021
13/08/2021
18/08/2021
19/08/2021
20/08/2021
23/08/2021
25/08/2021
27/08/2021
31/08/2021
Grand Total

 

[AlanY]

Ok I have now added another column, calculated field which takes the sum of the dates in the CW column. (see image). I now get a number, currently 19 but this is not the correct answer? As the pivot table changes due to the slicer selections, this number should change to reflect the count of the ones, but it doesn't. It does not change and stays on 19?

Screenshot is difficult to work with, could you share part of your sheet here, e.g. with XL2BB refer to my signature, or
share the file in google drive or similar

 

[bebo021999]

With dates are in CX column

=COUNTIF(CX:CX,">30000")

Count dates those later than 30000 (30000 equals 18-Feb-1982), to excluding other strange values within CX. Those values possible maximum 30000.