|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
09-05-2008, 03:42 PM
|
|||
|
|||
|
Sort Date Field in Excel 2007
I have a column of dates in the format of
August 24, 1981 January 10, 1983 April 2, 1984 February 11, 1985 May 16, 1985 January 1, 1986 I would like to sort by the month only. I have tried converting to datevalues, doing a LEFT of the field but nothing is working. Any ideas would be greatly appreciated. Thanks. Justine 
|
|
#2
09-05-2008, 03:48 PM
|
|||
|
|||
|
Thank you. I found the "MONTH" command and I can then sort on that.
Justine
|
 |
| Bookmarks |
New topics in Excel 2007 Help
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Populating a date field with todays date when data is entered in another cell | tlister3 | Excel Worksheet Functions | 3 | 05-28-2008 02:32 PM |
| Running Excel 4.0 Macro in Excel 2007. | CdSlc | Excel Programming | 0 | 03-26-2008 11:46 AM |
| Associating .xls files with Excel 2003 when Excel 2007 is installed | rocket_ron | Excel Miscellaneous | 1 | 03-12-2008 10:14 AM |
| Opening MS Excel 2007 file with xml in it but an xls file extension | patrick1234 | Excel Miscellaneous | 0 | 09-26-2007 12:52 PM |
| excel 2007??? why should/did i upgrade? | effang | Excel Miscellaneous | 3 | 04-05-2007 12:05 PM |
Linear Mode
