Need help converting a date to a sortable #

[VH5150]

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

 

[Norie]

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]

Good Point

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