How to make MS Excel return error if the date is wrong

How to make the below formula return an error since 31/Feb/2023 is a wrong date.

>Solution :

You can use this formula:

=IF(ISERROR(DATEVALUE(C2 & "-" & B2 & "-" & A2)),"not a valid date", DATE(C2,B2,A2))

DATEVALUE returns an error for e.g. 31/Feb/2023 but not for 28/Feb/2023.

I tested this on a German version … with dd.MM.yyyy as default setting.