DATE in English and Spanish
| English Excel | Spanish Excel | |
|---|---|---|
| Function name | DATE | FECHA |
| Syntax | =DATE(year, month, day) | =FECHA(year; month; day) |
| Example | =DATE(2026,12,31) | =FECHA(2026;12;31) |
Argument names are shown in English for reference. Spanish examples use the semicolon setting.
What DATE does
Builds a date from a year, a month and a day. Example: Builds December 31, 2026.
Semicolons, commas and decimals
Spanish versions of Excel separate arguments with a semicolon or a comma depending on the regional settings of the computer. With semicolons, decimals are written with a comma (3,14). With commas, decimals use a point (3.14). FormulaCheck converts both.
A common mistake
Arguments always go year, month, day, whatever your regional date format is.
Have a formula to translate or check?
Open FormulaCheckQuestions
Why does my Spanish Excel use semicolons?
Spanish versions of Excel separate arguments with a semicolon or a comma depending on the regional settings of the computer. With semicolons, decimals are written with a comma (3,14). With commas, decimals use a point (3.14). FormulaCheck converts both.
What is a common mistake with DATE?
Arguments always go year, month, day, whatever your regional date format is.