| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort By Date, Ignore Year
I have a need to sort a group of dates, ascending ignoring the year. the list
1/15/1960 1/06/1948 1/21/1980 1/1/1985 would be sorted as 1/1/1985 1/06/1948 1/15/1960 1/21/1980 Can any one help? What is needed to do this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sort By Date, Ignore Year
make a dummy column. Assume your first date is in A1
in row1 of the dummy column =Date(2000,month(a1),day(a1)) copy this down and sort using this column as your key I used a year of 2000 since it was a leap year. -- Regards, Tom Ogilvy SRBROTZ wrote in message m... I have a need to sort a group of dates, ascending ignoring the year. the list 1/15/1960 1/06/1948 1/21/1980 1/1/1985 would be sorted as 1/1/1985 1/06/1948 1/15/1960 1/21/1980 Can any one help? What is needed to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort by date but not year | Excel Discussion (Misc queries) | |||
| Using the sort function for a date column where year was not enter | Excel Worksheet Functions | |||
| Sort by date month and not year | Excel Discussion (Misc queries) | |||
| I want to sort by month, date, year. Birthdates. How do I do it | Excel Worksheet Functions | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
Linear Mode
