Forum Discussion
Solved
sorting dates
Hi, i have a list of dates where an activity (installation) occurred...and I would like to build a graph showing the volume of installations per day - across a period of several years. e.g. over ...
See the attached file. The data table has full dates displayed. The pivot table summarizes by month.
I guess "2017August" is the text, and texts are sorted alphabetically. You may format dates as "yyyy mmmm" and use them as dates.
- I dont seem to be able to find this can you advise please?
If I highlight a DATE and choose format cells, I dont see any options that only show month and year...they all include the day of monthSee the attached file. The data table has full dates displayed. The pivot table summarizes by month.
