Forum Discussion
Data Table with Dates and Pivot Table Date Format
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 i...
I cant attach a file
- 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 PainIs 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.
