I want to convert date in the format "dd.mm.yyyy" into serial.

Column B includes dates in the format "dd.mm.yyyy" I write a formula which is "=DATEVALUE(B2)" in a cell on column C. I get "#VALUE" error.

How to do that?