Statistic, Pivot table, Incorrect sorting

Hello! I made a table that displays employee birthdays in 2024. To do this, I applied a formula that replaces the current year. I have set up the view and sorting to display the nearest employee birthdays (within 1 month from today’s date).

The “Date” type is set in the column with the “formula” type.
When I make a pivot table, it sorts the dates as text, not as days. First come the numbers of months 0,1,2, etc. - in alphabetical order.