You could try with a helper column (that can be hidden) then using " Sort by" ( I suppose you will have no dates before 1941?)
Or a Power Query solution

Attached Files

Copy of Sorted Dates.xlsx (5.9 KB, 9 views)

__________________
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