How To Sort By Date In Excel 2011 For Mac

When sorting your Excel tables and worksheets in Office 2011 for Mac, you’re likely to use ascending and descending sort orders most often. The quick way to sort a table or data range is to select a cell in the column you want to sort. Then go to the Ribbon’s Data tab, find the Sort and Filter group, and click Sort. Select a table to sort, or select just specific rows in a column to sort. In the Organize sidebar, click the Sort tab. Click the pop-up menu in the sidebar and choose Sort Entire Table or Sort Selected Rows. Click Add a Column. Choose a column to sort by, then click the pop-up menu in the rule and choose Ascending or Descending.

In Excel for Mac, you can sort a list of data by days of the week or months of the year. Or, create your own custom list for items that don't sort well alphabetically. You can also sort. Question: In Microsoft Excel 2011 for Mac, I'm trying to put a chart in alphabetical order. There are 6 columns and over 2,000+ rows of information. I need to sort the data by column B (ie: Product column) in alphabetical order. Sorting: In Excel Sorting can be done easily manually. But here we are going to learn how to do sorting using Excel VBA/Macro. Mainly sorting can be of two types. Simple Sorting: Simple sorting is nothing but sorting alphabetically or by number in ascending or descending order.

How to sort birthdays (dates) by month/year/day only in Excel?

Normally the dates are sorted firstly by the year, then month, and at last the date in Excel, and it seems quite hard to sort dates only by the month with ignoring the year, even if the month is formatted at the beginning, such as Dec 12, 2011. However, sometime it may ask for sorting birthdays by month when sending birthday cards, or other reasons. This article is going to show you tricky tips to sort birthdays (dates) by month in Excel quickly.

Sort birthday (dates) by month/year/day only with Kutools for Excel
Sort birthdays (dates) by month only with Kutools for Excel

Sort birthdays (dates) by month/year/day only with Excel functions

The Excel’s Month function can help you to extract the month form the date, and then sort them by month and year quickly. Please do as follows:

1. In the adjacent blank cell of the dates, for example the Cell C1, enter the formula =Month (B2), and then drag this cell's AutoFill Handle down to the range as you need. And the months have been extracted from the birthdays. See screenshot:

Notes:
(1) For sorting by year only, please apply this formula =YEAR(B2);
(2) For sorting by day only, please apply this formula =DAY(B2).
(3) You can also apply the formula =TEXT(B2,'MMDD') to extract months and days from birthdays.

2. Keep selecting these months, and click Data > Sort Smallest to Largest or Sort Largest to Smallest.

3. In the opening Sort Warning dialog box, please check the Expand the selection option, and click the Sort button.

And now the dates have been sorted by the month only (or year/day only)at once. And you can delete the new column with month as you need.

Sort birthday (dates) by month/year/day only with Kutools for Excel

Apart from Excel functions, you can also apply Kutools for Excel’s Apply Date Formatting utility to extract the month/year/day only from birthdays (dates), and then you can sort birthday (dates) by month/year/day only.

Kutools for Excel- Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required!Get It Now

1. Copy the birthday column and paste next to original data.

2. Keep selecting the new birthdays in the new column, and click Kutools > Format > Apply Date Formatting. And now in the opening Apply Date Formatting dialog box, please select a date formatting and click the Ok button.

In our case, we select the date formatting which shows a date as month only. You can select the date formatting which only shows year or day of birthdays as you need. See screenshot:

3. Keep selecting the birthdays which show months only, click Kutools > To Actual, and click Home > Number Format > General successively.

And now months are extracted from all birthdays. See screenshots:

Kutools for Excel- Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required!Get It Now

4. Keep selecting the months of birthdays, click Data > Sort Smallest to Largest or Sort Largest to Smallest, and then in the Sort Warning dialog box check the Expand the selection option and click the Sort button. See screenshots:
So far we have sorted the birthdays by the month only (or sorted by the year/day only).

Sort birthdays (dates) by month or day only with Kutools for Excel

The above methods may be a little complex, however with Advanced Sort utility of Kutools for Excel, you can sort dates based on month directly and quickly.

Kutools for Excel- Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required!Get It Now

1. Select the list you want to sort the date by month and click Kutools Plus > Advanced Sort. See screenshot:

2. And then in the Advanced Sort dialog box, select the birthday column, and choose Month (or Day) from the Sort On drop down list, .and click the Ok button. See screenshot:

And now you can see the birthdays have been sorted by month (or day) only. See screenshot:

Kutools for Excel- Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required!Get It Now

Demo: Sort birthday (dates) by month/year/day in Excel

Kutools for Excel includes more than 300 handy tools for Excel, free to try without limitation in 30 days. Download and Free Trial Now!

The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

MS Excel 2011 For Mac: Sort Data In Alphabetical Order Based ...

Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.