I have a pivot and for some reason it won't sort dates correctly. ALL the dates are correct, but for some reason 2/3/2020 - 2/9/2020 isnt showing up correctly. The source file is all formatted correctly. In the source file, it sorts perfectly fine, just not in pivot. This is what shows up on the pivot sorted by newest first below, as you can see 2/3 isnt correct.
Row Labels Count of Candidate
1/27/2020 - 2/2/2020 8
2/10/2020 - 2/16/2020 12
2/17/2020 - 2/23/2020 23
2/24/2020 - 3/1/2020 8
2/3/2020 - 2/9/2020 11
3/9/2020 - 3/15/2020 1
4/27/2020 - 4/28/2020 1
Bookmarks