Sort Using Date Functions
 

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?

Sort Using Date Functions
 

No. You would need to set up dummy columns.

--
Regards,
Tom Ogilvy

"Dean" wrote in message
...
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?

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?