When dates are stored as text, they need to be formatted as a date.

The function Date Value converts a date to a$($n$)$

Short Date Format

Long Date Format

Excel S'rial Number

$00/00/0000$ format