Sort Using Date Functions

D

Dean

Is there a way to use the date functions on the Key
parameter of the SORT method? Instead of trying to have
the user type the date in YYYY/MM/DD, I wanted to the Year
and Month fucntions on the column range in order to sort
by Year and Month. Is this possible?
 
F

Frank Kabel

Hi
you could use a helper column with a formula like
=TEXT(A1,"YYYYMM")
and sort with this column
 
Top