date sort by month

S

skbwolves

Is there any way to sort a date format month/day/year by the month instead
of the year in Excel 2000?
 
A

Allen Browne

If you ask in one of the microsoft.public.excel groups, someone might know.

(This one is on MS Access, the database.)
 
J

Jamie Collins

skbwolves said:
Is there any way to sort a date format month/day/year by the month instead
of the year in Excel 2000?
Click to expand...

Same as for Jet e.g.

SELECT MyDateTimeCol
FROM [Excel 8.0;HDR=YES;Database=C:\Tempo\db.xls;].[Sheet1$]
ORDER BY MONTH(MyDateCol)
;

Jamie.

--
 
Top