Forum Home
Press F1
Thread ID: 31638	2003-03-27 23:51:00	Sorting Dates in Excel	Muzz (1286)	Press F1

Post ID	Timestamp	Content	User
131497	2003-04-06 09:50:00	Muzz, I just tried rugila's method and it works fine . Person Birthdate Sort date Billy T 1/1/1910 =DATE(50,MONTH(B2),DAY(B2)) Saddam 2/7/1944 =DATE(50,MONTH(B3),DAY(B3)) Dubya 8/11/1951 =DATE(50,MONTH(B4),DAY(B4)) Your spreadsheet sould look like the above for formulae Block mark ALL CELLS and data-sort- on the Sort date cell . You must highlight all cells for the sort . Otherwise the relationship of sorted date to name will be lost	godfather (25)
131498	2003-04-06 23:07:00	Muzz Godfather's comments should be useful. I just wanted to ask you for a bit more detail about why you couldn't get my suggestion to work. When you say it didn't sort as you wanted, just what if anything did it do, and at what stage did the suggested procedure fail? That approach in effect sets all dates as month and day in the same year (such as 1910, 1950, or whatever you like in fact as long as it is all in the same year. There are other workarounds or jackups in Excel to sort by month/day only but that one is by far the best of which I am aware. I would only suggest the following things you might watch out for. 1. When sorting, click on the menu - data - sort and make sure you have your "header row" or "no header row" properly selected. 2. (Although I don't think this onre shouild make any difference) Is your date format set to the NZ standard rather than the US standard . You can do this through the control panel?	rugila (214)
131499	2003-04-07 10:47:00	rugila....many thanks for yours and godfathers assistance...I had not blockmarked all the cells, thus the sort was not working...now works fine. your help is truly appreciated	Muzz (1286)
131500	2003-04-07 10:50:00	godfather .....many thanks for explaining that...I had not blockmarked all the cells and thus the sort was not working..........you guys are a huge help to those of us lacking in the finer skills!!	Muzz (1286)
1 2