Sort Using Date Functions

  • Thread starter Thread starter Dean
  • Start date Start date
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?
 
Hi
you could use a helper column with a formula like
=TEXT(A1,"YYYYMM")
and sort with this column
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sorting dates 3
Dates converted into text 5
Find a date in list less or equal than target date 4
Sort dates 4
Sort Date 3
InputBox Date Value 7
Excel is changing date format incorrectly 7
International Date formatting 4

Back
Top