Replace Sigma Value in excel pivot tables to date

[ferdie]

Is there a way to convert and/or replace say a count, in excel pivot table to a date. (no option for a date). Allow Sigma Values on the Pivot Table Field to use date.

 

[SpillerBD]

No. SIGMA and that area is used for calculated values.
The caveat is IF there is only one value calculated, such as only 1 value, MAX or MIN, you can use a date.