View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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?