Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort by Date Function
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort by Date Function
Insert a new column next to the actual birthdays - let's say they are in
column B, and you insert a new column C, and assume the dates commence in row 2. Use this formula in the new column C, row 2, then copy it down as needed, then sort on the new column =date(year(today()),month(b2),day(b2)) However, that may generate birthdays in 2007 but earlier than today, so you may want to use =if(date(year(today()),month(b2),day(b2))<today(), date(year(today())+1,month(b2),day(b2)),date(year( today()),month(b2),day(b2))) "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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort by Date Function
Assume employee birthdates in column B
Create helper columns in C & D In C2: =MONTH(B2) In D2: =DAY(B2) select both C2 & D2 copy down Select column B,C, and D Sort by column C, then Column D "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. |
#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. |
Reply |
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 |