How to sort dates with or without month

I have a column of dates in the following format:

  1. September 1891
  2. June 1829
  3. 1887
  4. 1917
  5. March 1904
  6. April 1904
  7. 1927
  8. December 1892

Is there any way to sort them in date order?

It might be a good idea to keep the data in separate columns. Then the set can be sorted by any column.

How would that sort the dates?
Each Month belongs to the Year.
Ah, sorry, I think I see what you mean.
l’ll have a go. Thanks.

I can’t make the date format like yours. Can you send a fragment of your table?

Thanks Frants. Separating the columns works fine.

The months aren’t sorted correctly when the Year is the same but I’m not bothered about that.

Actually there might be a bug there because I set the Date column to format Date(MMMM) and it still didn’t sort them correctly when the Years are the same.