LIST DATES IN MONTH ORDER
I have a list of dates etc and want to sort the list to show Month/Day - the
year is irrelevant for sorting purposes but still has to be shown in the final document. When I look into cells some have the date as 07/09/1999 and others as July 9, 1999 ( they have been prepared on both Excel Millenium and also Excell 2003) How can I achieve a printed list showing month/day/year please? (And then how do I prepare a list for printing labels?) -- keltis |
LIST DATES IN MONTH ORDER
One solution would be to create a column next to the list of dates which just shows the month number. IE: If your list was in column A, then the formula in column B for each cell would be: =MONTH(A1) etc, so if you had 10 dates in column A, then you would have 10 of the above formulas in column B. You could then perform a sort on the range A1:B10 using column B as the sort key. This column can always be hidden if necessary. -- Cumberland ------------------------------------------------------------------------ Cumberland's Profile: http://www.excelforum.com/member.php...o&userid=33445 View this thread: http://www.excelforum.com/showthread...hreadid=534157 |
All times are GMT +1. The time now is 07:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com