Sorting by day of the month

csuu · May 9th, 2002, 11:04 AM

Is there a way to sort by the day of the month? Example:

Data:
A1 8 May, 2002
A2 2 March, 2002
A3 25 Februay, 2002
A4 1 December, 2001

Desired result (ascending):
A4 1 December, 2001
A2 2 March, 2002
A1 8 May, 2002
A3 25 February, 2002

Larry

[ This Message was edited by: csuu on 2002-05-09 10:06 ]

Corticus · May 9th, 2002, 11:11 AM

use:

=DAY(A1) with A1 being the date cell.
Put this at the end of each row and sort the table by this column, make sure to include the rest of the table in the sort, though.

csuu · May 9th, 2002, 11:44 AM

Quote:

On 2002-05-09 10:11, Corticus wrote:
use:

=DAY(A1) with A1 being the date cell.
Put this at the end of each row and sort the table by this column, make sure to include the rest of the table in the sort, though.

Thanks!
Larry

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 11:04 AM	#1
csuu New Member Join Date: May 2002 Location: Larry Posts: 4	Is there a way to sort by the day of the month? Example: Data: A1 8 May, 2002 A2 2 March, 2002 A3 25 Februay, 2002 A4 1 December, 2001 Desired result (ascending): A4 1 December, 2001 A2 2 March, 2002 A1 8 May, 2002 A3 25 February, 2002 Larry [ This Message was edited by: csuu on 2002-05-09 10:06 ]

May 9th, 2002, 11:11 AM	#2
Corticus Board Regular Join Date: Apr 2002 Location: Sarasota, FL Posts: 1,539	use: =DAY(A1) with A1 being the date cell. Put this at the end of each row and sort the table by this column, make sure to include the rest of the table in the sort, though.