You have a problem in that some of your 'dates' are text. I have changed formatting to General: those that show as 5-digit serial numbers are dates, the rest are text.

AliGW on MS365 Beta Channel (Windows 11) 64 bit

D
E
1
Start Date
End Date
2
44774
31/07/2022
3
44928
31/12/2023
4
45292
31/03/2024
5
44565
31/12/2022
6
44927
31/05/2023
7
44932
31/05/2024
8
42747
30/11/2018
9
13/09/2021
44743
10
44569
31/12/2022
11
44927
31/01/2023
Sheet: Sheet1