How to sort a column by date in Excel with Python?

Question

Python

I am writing a Python program that inserts a date in the xlsx format into an excel table in the format dd.mm.yyyy

time_publication = 22.04.2021, type = <class 'str'>

I insert the date into the cell using the openpyxl library - the load_workbook, append function.
The line for adding the date to the nested list, which is then inserted line by line into the table:

time_publication = value.strftime('%d.%m.%Y') # это и есть итоговая дата, которую вставляю в столбец
list_in_res.append(time_publication)

I want to sort a column in a table by date. I changed the cell format to date, I click on the filter button, but there is no way to sort by date. He sees for some reason a column as a line. What could be the error?