To supplement the answer @chris-maurer gave, here is your spreadsheet with an added C column with the internal representation of each date
To convert your date to a string, use TEXT(A1,"dd/mm/yyyy") etc.
TEXT(A1,"dd/mm/yyyy")