Date in exel

[Sudharsan_Ka]

@pl.rusinov
If these case happened again what you need to do is simply add that date format in the array you used in the expression

@Sudharsan_Ka

{"dd.MM.yyyy","MM/dd/yyyy hh:mm:ss","dd/MM/yyyy hh:mm:ss","dd-MM-yyyy","dd.M.yyyy"}

What error you had 10.1.2023 was not recognized means it cant find the correct format in the array of you had before

10.1.2023- dd.M.yyyy

So in the latest expression i shared i have added the new format in array i used in the expression

You just need to add the new expression by seperated as comma
{“dd.MM.yyyy”,“MM/dd/yyyy hh:mm:ss”,“dd/MM/yyyy hh:mm:ss”,“dd-MM-yyyy”,“dd.M.yyyy”,“New Format”}

Regards
Sudharsan