| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort by Date Function
Assuming dates are in column A.
In B1 enter =MONTH(A1) then double-click on fill handle of B1. Sort on column B Gord Dibben MS Excel MVP On Thu, 30 Aug 2007 09:16:06 -0700, Kat wrote: I want to sort a list of employees birthdates but I only want to sort them by month then date not year. When I do a sort function it will sort by the year. Does anyone know how to have it sort the other way. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort : how can I use a variable in a VB sort function? | Excel Worksheet Functions | |||
| sort function to sort for bell curve | Excel Discussion (Misc queries) | |||
| Complicated sort function with sort and sum | Excel Worksheet Functions | |||
| In Excel, why sort function fails when applied to a list of date? | Excel Discussion (Misc queries) | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Threaded Mode
