How do I sort by date in excel? I sell books and I can generate a report to show all my open listing, but I?

Question

How do I sort by date in excel? I sell books and I can generate a report to show all my open listing, but I only want certain dates. The dates don't go in order. The dates show up as 2006-12-31, 2007-01-02. How do I sort out the date with the item that is on the same column? Thanks so much!

Out of the Night [Hardcover] by Jan Valtin1228B077226482.412006-12-28 22:50:23 PST

That's what it looks like but on one column across.

Answer 1

select the data
goto
data
sort
and follow the prompts

Answer 2

I assume you have selected the full width and depth of all your records. On the menu you will find Data > sort. If you include top row in your selection, you will see all the field names > choose date > hit OK.
I'll assume your dates have all been entered in the same format eg date cf text . . . . After the sort, check the result looks ok before resaving. To select between ranges of dates, use the Help facility, or merely highlight the range you want to print.
Hope this helps

Answer 3

Make sure all of your dates are in one collum then :
Highlight all of your data
then in the menu bar select Data then sort
a window will come up and you will then select by collum
(and it is what ever solt you have all your dates in )

and to get the date to be normal select the collum your dates are in and selected modify collum another box will show up and select numbers then Date and you can have your dates displayed which ever way you want them to so it can say 01/07/07 instead of 2007-01-07

Answer 4

All the dates and ONLY the dates need to be either in one column or one row. Column is much easier.