Sorting Dates

[oskar44]

In my workbook sheets I have a date column and on my UserForm I have a txtBox which picks the date from the date column. I want to sort the date column in descending order (current year first) but it does not work, dates are mixed and I think the date format may be the problem

I prefer my dates in this format Jul-10-15 but the format cells date does not have this format available (Excel 2013). Is there another way to force Excel to accept the format I prefer?

If I want to have the date column sorted in descending order and have the current year and then the months in order do I need to have the date like 15-Jul-10 or I can have it like Jul-10-15 and it will get the 15 at the top?

[Ed_Collins]

As far as formatting is concerned, try this as a custom format: rmmm-dd-yy. That should give you Jul-10-15.

Whatever your format is, as long as Excel knows it's a date, sorting in descending order should work. Recall that the date is just a number... the number of days since 1/1/1900, if I remember.

[oskar44]

Thanks Ed, I will give it a try

[oskar44]

It works well Ed but the dates now appear like rJul-11-15. Is there a way to get rid of the (r) ?

[Ed_Collins]

I'm so sorry. That's a typo on my part. That r doesn't belong. Try just this: mmm-dd-yy

[oskar44]

No problem Ed, all is fine now, thanks