View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Sort Date Column

With data as wuch; if you do the normal sort what happens?

If this post helps click Yes
---------------
Jacob Skaria


"CAL" wrote:

I have a date column in the yyyy-mm-dd format. I want the user to be able to
sort the worksheet by month. Is there a way I can pull only the month from
the date field and allow the user to sort on that and have the worksheet
display all rows that fall within that month.
Example May - all columns with a date of 2009-05-01 through 2009-05-31 would
display.

PS - I am running Excel 2002