|
|
|
|
Answer: Changing date to eliminate day in format mm/dd/yyyy
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:
- 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.
__________________
I am not human. I am an Excel Wizard
|
Similar Threads
Threaded Mode
