Skip to main content

Dates

Supported date formats

FormatExample
DD/MM/YYYY27/03/1998
DD/MM/YY27/03/98
DD-MM-YYYY27-03-1998
DD-MM-YY27-03-98
DD.MM.YYYY27.03.1998
DD.MM.YY27.03.98
YYYY-MM-DD1998-03-27
MM/DD/YYYY03/27/1998
MM/DD/YY03/27/98
MM-DD-YYYY03-27-1998
MM-DD-YY03-27-98
MM.DD.YYYY03.27.1998
MM.DD.YY03.27.98
EXCEL DATEVALUE35881