Select a cell in the date section, then select the Data tab and click. The dates will now be converted and displayed as the month and year only. Once the Format Cells dialogue box is open, select Custom and either enter mmm-yy in the Type box or scroll down to select the right format. Select your date range and on the Home Tab, select More Number Formats from the General drop down list in the Number section. Select a cell within your date range and from the Data tab select the sort A>Z button to sort your dates in the correct order.Īpply a date format to display your date range as Month and Year. To subtotal by month and year following these simple steps: This will remove all table functionality from the data except the table formatting. To convert your data, from the Table Tools > Design menu, select Tools > Convert to Range. If your data is in a table format, you will first need to convert the table to a normal range of data before following the below steps. You are welcome to download the workbook to practice.Īpplies To: Microsoft ® Excel ® for Windows 2010, 2013, and 2016. However, when using the Subtotal command, the desired result is not being achieved as it creates a subtotal for each day. If your data has a column of dates, you may want to subtotal dates by month and year.