Category by birth day in Excel by using the custom Category preference in the Central tab.
Advantage Excel to Category material in your worksheets. When sorting news, compose firm you employment the Correct information formats. This can be done by changing the cell properties to the capture facts format. When sorting dates, hire the date format that you hankering to account and operate it to all of the cells in the area. Once this is done, sorting can be done using the Category options on the Familiar tab.
2. Highlight the range of data containing the birth dates. Right-click the highlighted range and select "Format Cells." On the "Number" tab, select the "Date" category. Select the date format that you want to use. Click "OK." All of your dates will now display the same format.3.
Instructions
1. Accessible Excel 2007 and select a workbook containing birth date data. Click the "Office" button and select "Open." Browse your files and locate the workbook. Click the workbook and select "Open." The workbook opens.Highlight the entire range that you want sorted. Click the "Sort & Filter" button on the "Home" tab. Select "Custom" sort. In the drop-down list, select the column that contains your birth date information. Select "Largest to Smallest" order and click "OK." Your data is now sorted by the birth date in Excel.
