Comments on: How to sort by date in Excel: in chronological order, by month, auto sort

Excel's built-in sort options are powerful and effective tools, but they do not always work correctly when it comes to sorting dates. This tutorial will teach you a few useful tricks to arrange Excel spreadsheets by date in a meaningful way without messing up your data. Continue reading

Comments page 2. Total comments: 42

  1. Hi Alexander,
    How can I auto sort multiple data fields on one spreadsheet.

    For Example using example given. if you split the citrus fruit and the other fruit into to separate data fields. Hope that makes sense.

    I believe that is what Matt is asking for above, post 6.

    Cameron

  2. I have been searching for hours to find a way of writing dates so that they can be sorted.
    In spite of reading everything with great care nothing seems to work in the way that it should.
    Even the simple things, if I write a four figure no. and irrespective of which format I use, Excel accepts that no. as either 2units + 2 decimal places or the decimalised figure rounded up to the next whole no.
    For example 1785 would be shown as 17.85 or 18.
    What am I not doing ?

    1. Hello!
      I’m sorry but your task is not entirely clear to me. Could you please describe it in more detail? 1785 is a number, not a date. Please specify what you were trying to find, what formula you used and what problem or error occurred. Give an example of the source data and the expected result.
      It’ll help me understand it better and find a solution for you.

  3. Is there a way to make the same code but with multiple sort layers?

  4. Need help posting a formula that will automatically sort by date after after new entries are made.

    0000-00 Smith John Doe 1/1/87 Monday, October 22, 2001 LV

    I have 7 columns and I would like it sorted by date or column 6.

    Can anyone advise how to accomplish this?

  5. NOTHING TO UNDERSTAND

  6. Sort data into student quiz and arrange marks in descending order one example

  7. Respected Sir i want short by subject of the student for examples
    Sr. No. Name Student ID Subject
    1. Ram BA20201 Hindi, English, History,
    2. Shyam BA20202 Sanskrit, Political Science, History
    3. Mohan BSC20192 Music, Drama, History
    4. Sohan BCom Hindi, English, Accounting
    now i want to know how many student has taken Hindi and with hindi which subject taken by all the student those who have take hindi

    1. Hello!
      To calculate the number of students, use the formula

      =COUNTIF(D2:D40,"*Hindi*")

      To get a list of subjects, each of them must be recorded in a separate column. Then you can apply this instruction.

  8. thanx,do u provide hep in all office tools?

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)