How To Sort Dates In Ascending Order in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 26 ส.ค. 2024

ความคิดเห็น • 9

  • @mariaboghean2759
    @mariaboghean2759 3 ปีที่แล้ว

    Very useful info! Thanks for sharing!

  • @schalkferreira8008
    @schalkferreira8008 7 หลายเดือนก่อน

    My dates are short dates but when I sort it does not sort from lowest to highest it is resorting it but not in chronological order? What can be wrong?

    • @cogwheelLearning
      @cogwheelLearning  7 หลายเดือนก่อน

      Have you checked if they are formatted as dates? The format could be General and it might mess with the sorting

  • @RocketMyDog1
    @RocketMyDog1 2 ปีที่แล้ว +2

    Sorts by month and day, but not by year.

    • @cogwheelLearning
      @cogwheelLearning  2 ปีที่แล้ว

      Hmm, that doesn't sound right. Perhaps there's something wrong with the data?

  • @cogwheelLearning
    @cogwheelLearning  3 ปีที่แล้ว

    🚨 Checkout this playlist for more Microsoft Excel tips:
    th-cam.com/play/PLQHFVtY7qRaufg0mmtiP3NWvHJCo0WT07.html

  • @ChallengerRhino
    @ChallengerRhino 3 ปีที่แล้ว

    American dates are so frustrating when you get data from the US and you need to work with it in Europe and Excel thinks, for example, that 01/01/2021 is a valid date, but 24/01/2021 isn't.

    • @cogwheelLearning
      @cogwheelLearning  3 ปีที่แล้ว

      Excel is really weird with dates sometimes 😂