Hi Jay, I really think so, but, for how many rows are you talking about?

regards

"Jay.... Needing help" escreveu:

Is there a way to make it do it automatically?

"Marcelo" wrote:

Hi Jay,

assuming your data is on Column A rows 2 thu 30

on B2 use a formula =day(a2) it will return 6 on 6/6/06

copy this formula down thu b20.
select the data A and B column and sort by B (days)

hth
regards from Brazil
Marcelo


"Jay.... Needing help" escreveu:

Can you be alittle more specific..... I am pretty quick about picking this
up , but I'm only used to roking with add subtract... etc....

Can you give me step by step instructions on how to do this?

"LarryLL" wrote:


The function day(datevalue) will give you the day of the month.
Put this in a column,
select that area to sort,
go to menu item Data - Sort and specify the column as the sort field.

Hope this helps.


Jay.... Needing help Wrote:
I am setting up a cell that will show what day of the month a certain
customer signed up with the company.... is there a formula that will
allow
the whole spread sheet adjust to cronologiacl order based off that day
of
(any) month...
EX:
Day of Month
6
6
6
7
7
7
7
8
8
8
8
8


--
LarryLL
------------------------------------------------------------------------
LarryLL's Profile: http://www.excelforum.com/member.php...o&userid=36136
View this thread: http://www.excelforum.com/showthread...hreadid=559441