\<bookmark_value\>DATE function\</bookmark_value\>

DATE

This function calculates a date specified by year, month, day and displays it in the cell's formatting. The default format of a cell containing the DATE function is the date format, but you can format the cells with any other number format.

Syntax

DATE(year; month; day)

\<emph\>Year\</emph\> is an integer between 1583 and 9956 or 0 and 99.

In - LibreOffice - General you can set from which year a two-digit number entry is recognized as 20xx.

\<emph\>Month\</emph\> is an integer between 1 and 12 indicating the month.

\<emph\>Day\</emph\> is a number between 1 and 31 indicating the day of the month.

If the values for month and day are higher, they are carried over to the next digit. If you enter =DATE(00;12;31) the result will be "12/31/00." If, on the other hand, you enter =DATE(00;13;31) the result will be "1/31/01."

Example:

DATE("00;1;1") yields 1/1/00