Yes, I thought I was pushing the bounds of possibilities, still it was worth a try as I know that there are some really smart bunnies out there.

Thanks anyway.

A simplest solution - replace all non-date numeric entries (year numbers) manually with dates. E.g. instead 1965 enter a date like 01.01.1965, and instead 1985 enter 01.01.1985.
In case you want to display them as year numbers, simply format those cells as custom "yyyy" (but this is not obligatory). Now sorting by date returns exactly what you want.

In case those data are read dynamically form some database, the solution can be more tricky, involving a helper column where all non-date entries are replaced with calculated dates, and date entries with copy of dates, using some complex formula. Then you can sort by this helper column.

If you take a minute to open the file I posted that is EXACTLY what I did.

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi Pecoflyer,

I apologize most profusely, I did open the file but didn't take in exactly what was happening, sorry. OK that does sort things as I wanted.

Next question, when you set up a sort filter all columns are selected. Is there a way of disabling one columns sort filter without effecting the use of the others. As you can see, if you sort the Date column it doesn’t come out the same, because it’s looking at the date number.

Best Rgds,
Dave R.