Sorting by month date - Again - dd.mm.yy format, only sorts by day.

Hi Greenstair and welcome to the forum,

This doesn't sound too hard, if we could see some sample data. I need to see if the "dates" are text or real numbers and how they are formatted. If you can figure out how to attach a sample file, there is a good chance we can give a quick answer.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi Marvin,
Many thanks - sorry for the delay - my notification settings weren't set, so hadn't seen your post...
Attached is the offending article. I'm trying to sort by Column A "Date" - as usual, it sorts by day and ignores the month and year (although the year isn't really important, as the client creates a new tab for each year and as such, they have historically simply added a row for each entry and never sorted). What I think happened is that an office admin sorted by client to find something, and then saved and this wasn't picked up - hence they're in a pickle and crying :-/
G