Date sorter

[driver]

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>

 

[Norman Jones]

Hi Driver,

Provided that your data input includes
a date field, it should be possible to
sort the data with a single click of
Excel's sort icon - unless there is an
element of your question which has
escaped me.

 

[Dave]

Hi,
You can enter them in any order you like.
Just make sure the dates for each receipt are in the same column - doesn't
matter which one.
When it's all entered, select all the data. From the DATA menu choose SORT,
and tell XL which column your dates are in, press ok.
Regards - Dave.

 

[Gord Dibben]

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 Data>Sort>Sort
ascending on the Date column.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

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

 

[Ron de Bruin]

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