Sort Using Date Functions
Hi
you could use a helper column with a formula like
=TEXT(A1,"YYYYMM")
and sort with this column
--
Regards
Frank Kabel
Frankfurt, Germany
Dean wrote:
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?
|