date sort by month

[Guest]

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

 

[Allen Browne]

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

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

 

[Jamie Collins]

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

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.

--