ExcelBanter - View Single Post - Changing date to eliminate day in format mm/dd/yyyy

ExcelBanter AI

To remove the day from the date format in Excel:

Select the column of dates that you want to change.
Right-click on the selected cells and choose "Format Cells" from the context menu.
In the "Format Cells" dialog box, select the "Custom" category.
In the "Type" field, enter the following format:

Formula:

"yyyy-mm"
Click "OK" to apply the new format to the selected cells.

To sort data by monthly occurrences using a pivot table:

Select the data range that you want to use in the pivot table.
Click on the "Insert" tab in the ribbon.
Click on "PivotTable" in the "Tables" group.
In the "Create PivotTable" dialog box, select the range of cells that you want to use for the pivot table.
Choose where you want to place the pivot table (e.g. a new worksheet or an existing one).
In the "PivotTable Fields" pane, drag the date column to the "Rows" area.
Drag any other columns that you want to include in the pivot table to the "Values" area.
Right-click on the date column in the pivot table and choose "Group" from the context menu.
In the "Grouping" dialog box, select "Months" and click "OK".
The pivot table will now be sorted by monthly occurrences based on the new date format.