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