DATE

此函式會計算由年、月、日所指定的日期，並以儲存格格式顯示。包含 DATE 函式的儲存格預設格式為日期格式，但您可使用任何其他數字格式來格式化此儲存格。

語法

DATE(Year; Month; Day)

Year 是介於 1583 和 9957 或介於 0 到 99 之間的整數。

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

Month is an integer indicating the month. A value between 1 and 12.

Day is an integer indicating the day of the month. A value between 1 and 31.

If the values for month and day are out of bounds, they are carried over to the next digit. If you enter =DATE(2000;12;31) the result will be 2000-12-31. If, on the other hand, you enter =DATE(2000;13;31) the result will be 2001-01-31.

To avoid ambiguity, always use four digits for years.

For Integer arguments, non-integer values are truncated to Integer.

範例

=DATE(00;1;31) yields the date 2000-01-31 written as 01/31/00 if the cell format setting is MM/DD/YY.

Technical information

This function is part of the Open Document Format for Office Applications (OpenDocument) standard.

DATE wiki page.

Date & Time Functions

DATE

[text/scalc/01/func_datedif.xhp#datedif not found].

[text/scalc/01/func_isoweeknum.xhp#isoweeknum not found].

[text/scalc/01/func_weeknum_ooo.xhp#weeknum_ooo not found].