sort by calendar date in excel

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

[gls858]

wrote:

> 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


> wrote in message
...
| 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.

--=20
----------------------------------------------------------
http://home.comcast.net/~wizardofwhimsy/index.html
> wrote in message =
...
> I would like to sort data by calendar dates, beginning in=20
> January, is there a way I can program Excel to do that?

Thanks that was helpful.
>-----Original Message-----
>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
>
>
> wrote in message
...
>| I would like to sort data by calendar dates, beginning
in
>| January, is there a way I can program Excel to do that?
>
>.
>

[M. Rajesh]

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.
--
Regards
M. Rajesh
..Net and Windows Shell MVP
www.winxpsolution.com


" wrote:

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