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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 05:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com