sort date up to month

T

Tobias Weber

Hi,
my date column contains Y-M-D, but I want to only sort by Y-M and withn
each month by another column (name). How?
 
B

Bernard Rey

Tobias Weber :
my date column contains Y-M-D, but I want to only sort by Y-M and within
each month by another column (name). How?
Click to expand...

One way: use an additional column, with a formula like this (referring to
the date in column A):

=DATE(YEAR(A2),MONTH(A2),1)
 
P

PhilD

Bernard said:
Tobias Weber :


One way: use an additional column, with a formula like this (referring to
the date in column A):

=DATE(YEAR(A2),MONTH(A2),1)
Click to expand...

Another way, keeping it really simple (technically), would be to sort
by date and then do individual sorts within each month grouping. This
of course is more suited to sorting only once or twice, not frequently.

PhilD
 
Top