JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,691
- Office Version
- 365
- Platform
- Windows
Is there way to sort a column of dates on just the month and day, ignoring the year? This is the only way I could think of by adding a helper column.
Family Database.xlsx | |||||
---|---|---|---|---|---|
B | C | D | |||
3 | DoB | Age | mm/dd | ||
4 | 2/03/1944 | 79.0 | 0203 | ||
5 | 2/14/1999 | 24.0 | 0214 | ||
6 | 2/25/1963 | 60.0 | 0225 | ||
7 | 4/06/1968 | 54.9 | 0406 | ||
8 | 6/19/1997 | 25.7 | 0619 | ||
9 | 7/06/1949 | 73.6 | 0706 | ||
10 | 8/30/1968 | 54.5 | 0830 | ||
11 | 11/13/1951 | 71.3 | 1113 | ||
12 | 11/15/2005 | 17.2 | 1115 | ||
13 | 12/08/2007 | 15.2 | 1208 | ||
14 | 12/13/1945 | 77.2 | 1213 | ||
15 | 12/19/1966 | 56.2 | 1219 | ||
MrExcel-02 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C4:C15 | C4 | =IF( IsADate([@DoB]),CONVERT(TODAY()-[@DoB],"day","yr"),"") |
D4:D15 | D4 | =TEXT([@DoB],"mm") & TEXT([@DoB],"dd") |
Named Ranges | ||
---|---|---|
Name | Refers To | Cells |
'MrExcel-02'!DoBBurke | ='MrExcel-02'!$B$14 | C14:D14 |
'MrExcel-02'!DoBWes | ='MrExcel-02'!$B$4 | C4:D4 |