sort date up to month

[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?

 

[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?

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

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

 

[PhilD]

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)

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