excel consultant - Organising information in date order

Hi Krystle

Thank you for your question.

You would first need to ensure that:

1. All your dates were in one column
2. The column containing the dates had a heading at the top (e.g. Date) which has been bolded.
3. All dates are in the same format.
4. There are no blank rows within the list of dates.

Then you can select any of the cells that contain a date, then click the Sort Ascending button on the standard toolbar (button with A and Z on it).

Amanda