|
|
#1
06-18-2015, 09:52 AM
|
|||
|
|||
Sorting dates without year
I have a listing of nearly 1000 birthdays ranging from 1900 to current. I'd like to sort the list by month and day without the year impacting. So I would end up with 12 birthday lists by month and not using or showing the year. Thanks 
|
|
#2
06-18-2015, 11:44 AM
|
||||
|
||||
|
Hi
You would perhaps have to use two helper columns, one containing the month ( =MONTH(A1) and the other the day ( =DAY(A1)) and sort first according to month then to day
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#3
06-18-2015, 12:47 PM
|
|||
|
|||
|
Pecoflyer. Thanks. It takes a few steps but it works. Thanks again.
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to search for a specific year from a table with year range? | Wii | Excel | 0 | 05-05-2015 12:40 PM |
| How to calculate a rolling year-to-date percentage by quarter as the year progresses | sleake | Excel Programming | 2 | 04-23-2015 11:51 AM |
 Networkdays per fiscal year in a 6 year range
|
jabnm | Excel | 1 | 10-16-2014 11:51 AM |
| Year to Year in Fillable form | Lara | Word | 1 | 04-09-2013 03:19 PM |
| Creative Ways for a year-to-year comparison??? | ridonkulous5 | Excel | 1 | 03-23-2011 04:49 PM |
Windows 7 64bit 
Office 2010 64bit
Linear Mode
