I like to add this to Gord's reply

A reminder..........make sure the dates are entered in a format acceptable to
Excel which of course dpends upon the short date setting in Windows Regional and
Language Settings.

The ISO date format will always work

yyyy-mm-dd

If you want to read more see
http://www.rondebruin.nl/isodate.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
A reminder..........make sure the dates are entered in a format acceptable to
Excel which of course dpends upon the short date setting in Windows Regional and
Language Settings.

i.e. SD settings are mm/dd/yyyy

Don't enter dates as dd/mm/yyyy or tExcel will treat them as text and won't
sort properly.


Gord


On Sat, 03 May 2008 10:50:38 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Open a new workbook.

In A1 enter the word Date.

In A2 start entering the date on each receipt and other info across the row in
separate cells.

Work your way down in any order.

When you get all recipts entered select all columns then DataSortSort
ascending on the Date column.


Gord Dibben MS Excel MVP

On Sat, 3 May 2008 10:36:01 -0700, driver
wrote:

I have a box full of recipets (1 or 2 a day for the last 2 yrs) Now i have to
have them in order by date. I know im going to have to put them in the pc by
hand but is there a sorter that will arange them by date