sort by calendar date in excel

[Guest]

I would like to sort data by calendar dates, beginning in
January, is there a way I can program Excel to do that?

 

[gls858]

I would like to sort data by calendar dates, beginning in
January, is there a way I can program Excel to do that?

You will get better help with Excel problems here
microsoft.public.excel.newusers

gls858

 

[Will Denny]

Hi

You may like to direct your question to the Excel News Group:

news://msnews.microsoft.com/microsoft.public.excel

--

Will Denny
MS-MVP Windows - Shell/User
Please reply to the News Groups


| I would like to sort data by calendar dates, beginning in
| January, is there a way I can program Excel to do that?

 

[David Candy]

What's a calandar date? Format the cells as date.

 

[Guest]

Thanks that was helpful.

 

[Guest]

Well you have to select the column and then right click on the column and choose formatting and then set the column to be date format with your preference how you want the date to be displayed.

then select all the data in the sheet and choose data | Sort and then choose the column that has the date column and then click apply.