How sort date (mm/yyyy) by year

**Joe Walsh** · 08-09-2013, 10:12 AM

Hi all,

I have worksheet of data that I need to sort by year then month. Currently when I try to sort the data by data excel sorts by the month then year. Does anyone know how to reverse this so the dates are sorted by year then month???

Thanks!

**FDibbins** · 08-09-2013, 10:43 AM

1st, check that your dates are actually dates and not text that looks like dates - use =isnumber(cell-ref). If they are text, depending on how they were entered, you may be able to use text2columns to convert them

Keep in mind that a date in excel is a 5-digit number representing how many days have passed since 1/1/1900, so sorting them will work, no matter what format they are in

How sort date (mm/yyyy) by year

LinkBack

Thread Tools

Rate This Thread

Display

How sort date (mm/yyyy) by year

Re: How sort date (mm/yyyy) by year

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Date Filter Dropdown - Some in Expandable Year->Month->Day format; others just mm/dd/yyyy

[SOLVED] Sort worksheets by date (MMM YYYY)

VBA Macro to capture DATA in dd/mm/yyyy even though system date format is mm/dd/yyyy

[SOLVED] Imported data contains strings dd.mm.yyyy how can I convert to date format dd/mm/yyyy inVB

opening excel file -> date format problem: DD/MM/YYYY vs MM/DD/YYYY

Bookmarks

Bookmarks

Posting Permissions