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 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 month
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 month
See the attached file. The data table has full dates displayed. The pivot table summarizes by month.