Data Table with Dates and Pivot Table Date Format

[AdamRiffe]

Hello all, I'm using Microsoft Excel in 365.  I've got a data table that I use to create multiple Pivot Reports.  Some times my dates are reflected as a number in the Pivot Report Filter and I need it to reflect the date.  Any suggestions for this?  The Columns in the table for the dates are formatted as a date.  

[#2]

@AdamRiffe 

Please provide a sample file.

[#3]

I cant attach a file

[#4]

Patient# Account Encounter Encounters Visit# Referral# Patient Law Firm Facility Facility Type Doctor Provider Type Location Ref. By Ref. Date Ref. Month Ref. Year
1 1 1 1 1 1 ABC Firm Website 7/28/2021 7/31/2021 2021
2 1 2 1 1 1 DEF Firm Website 10/2/2020 10/31/2020 2020
3 1 3 1 1 1 GHI Firm Location 1 Surgery Center DR1 Spine Facility 44379 7/31/2021 2021
4 1 4 1 1 1 JKL Firm2 DR2 Pain Attorney 5/22/2020 5/31/2020 2020
4 0 5 0 2 0 JKL Firm2 DR3 PT Attorney 5/22/2020 5/31/2020 2020
5 1 5 1 1 1 MNO Firm3 DR4 PT Website Call 11/3/2018 11/30/2018 2018
6 1 6 1 1 1 PQR Firm4 Location 2 Surgery Center DR5 Orthopedic Facility 1/15/2015 1/31/2015 2015
7 1 7 1 1 1 STU Firm5 DR6 Pain LHP 4/28/2020 4/30/2020 2020
8 1 8 1 1 1 VWX Firm6 DR7 Pain/Spine Marketing Event 9/18/2019 9/30/2019 2019
9 1 9 1 1 1 YZA Firm7 DR8 Podiatry Attorney 8/19/2018 8/31/2018 2018
10 1 10 1 1 1 BCD Firm 8 Location 3 Surgery Center DR9 Pain Facility 43746 10/31/2019 2019
11 1 11 1 1 1 EFG Firm9 Location 4 Surgery Center DR10 Pain
11 0 12 0 2 0 EFG Firm9 Location 5 Anesthesia Anesthesia
11 0 12 1 1 0 EFG Firm9 Location 4 Surgery Center DR10 Pain

[#5]

@AdamRiffe 

Is it possible exactly the same but as Excel file? Perhaps you have mix of texts which looks like date and actual dates. Hard to say without the file.