Need help converting a date to a sortable #

VH5150

Board Regular
Joined
Mar 1, 2004
Messages
60
I have a column of cells with a date formatting like Jun-04. I would like to place a column beside it that has the serial date so I can sort the column in chronological order. Any ideas? Thanks,

Eddie
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,059
Office Version
  1. 365
Platform
  1. Windows
Eddie

Are these actually dates, just formatted for month/year?

If they are then you shouldn't need to change them to sort them.
 

VH5150

Board Regular
Joined
Mar 1, 2004
Messages
60
Good Point

This works! Maybe I'm retarded. Sorry to waste your time.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,521
Messages
5,572,628
Members
412,475
Latest member
JaredNAU
Top