How to sort dates from Oldest to Newest in Excel

0 votes

I have code that brings data in a database to Excel.

For it to be versatile the cells are formatted as "General". This worked.

Now someone wants to sort dates "Oldest to Newest" but the only option that shows up is A to Z or Z to A.

I followed all suggestions found in How to sort by dates excel?. Going through all those steps I did see the proper sort appear, so I recreated the workbook to reproduce this but could not.

Why doesn't formatting the column as a date display the "Oldest to Newest"?

What steps are required to get the sort options to display "Oldest to Newest"?

I press F2 and it does not work. I click on a cell in the original column that was general changed to date but it does not work. I click on the column header in the original column that was general changed to date but it does not work. I click on a cell in the new column that pasted values special but it does not work. I click on the column header in the new column that pasted values special but it does not work.

Feb 23 in Database by Edureka
• 13,640 points
454 views

1 answer to this question.

0 votes
  1. Drag down the column to select the dates you want to sort.
  2. Click Home tab > arrow under Sort & Filter, and then click Sort Oldest to Newest, or Sort Newest to Oldest.
answered Feb 23 by gaurav
• 22,040 points

Related Questions In Database

0 votes
1 answer

how to change format of date from mm/dd/yyyy to dd-mmm-yyyy in MS Excel

First, pick the cells that contain dates, ...READ MORE

answered Apr 11 in Database by gaurav
• 22,040 points
56,923 views
0 votes
1 answer

How to sort the data in sql ?

Hi Akash,  If you want to sort ...READ MORE

answered May 29, 2019 in Database by sampriti
• 1,120 points
412 views
0 votes
0 answers

How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

 need the row/column combinations marked with an ...READ MORE

Feb 24 in Database by Edureka
• 13,640 points
787 views
0 votes
1 answer

How to count distinct values in Excel

Use functions to count the number of ...READ MORE

answered Mar 15 in Database by gaurav
• 22,040 points
529 views
0 votes
1 answer

Disable Sorting in excel

Go to the Home ribbon, click the ...READ MORE

answered Jun 9 in JQuery by gaurav
• 22,040 points
36 views
0 votes
1 answer

Sort Excel worksheets based on name, which is a date

Sorting sheets of a workbook are rather ...READ MORE

answered Oct 17 in Others by narikkadan
• 37,660 points
47 views
0 votes
0 answers

Excel: How to Sort or filter text by specific word or words?

Even if the term is used in ...READ MORE

Nov 27 in Others by Kithuzzz
• 20,660 points
13 views
0 votes
1 answer

How can I Sort an ArrayList in Java

You can sort the ArrayList in 2 ...READ MORE

answered Apr 23, 2018 in Java by sharth
• 3,350 points
422 views
0 votes
1 answer

How to sort by dates excel?

You can sort dates in a worksheet ...READ MORE

answered Mar 31 in Database by gaurav
• 22,040 points
88 views
0 votes
1 answer

How to download excel in response from api react.js

Create ReactJS project import React, { Component } ...READ MORE

answered Mar 31 in Database by gaurav
• 22,040 points
3,519 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP