Dates not sorting Properly in Excel

traversd

Board Regular
Joined
Mar 17, 2002
Messages
82
Hi,
I have a colutmn of dates that are part of a table. The data is input via a form (Thanks to Audiojoe for the spinbutton code) and then sorted.

The problem seems to be that the dates are only sorted on the day part of the data (format is dd/mm/yyyy) Therefore the 16/04/2002 is coming before 25/03/2002.

This little nuance is wrecking my home made task / to-do list app !!

Any help greatly appreciated.

Regards
Darren
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
It appears your dates are entered as text. You will need to convert them to numbers for Excle to sort them properly. Easiest way is to multiply each date by 1 and reformat. Place the number 1 in a empty cell, copy it, and then do a paste special Multiply on your date column.
This message was edited by lenze on 2002-03-25 09:32
 
Upvote 0

Forum statistics

Threads
1,213,558
Messages
6,114,297
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top