public class DateValue extends Fixed1ArgFunction
Syntax:
DATEVALUE(date_text)
The DATEVALUE function converts a date that is stored as text to a serial number that Excel recognizes as a date. For example, the formula =DATEVALUE("1/1/2008") returns 39448, the serial number of the date 1/1/2008. Remember, though, that your computer's system date setting may cause the results of a DATEVALUE function to vary from this example
The DATEVALUE function is helpful in cases where a worksheet contains dates in a text format that you want to filter, sort, or format as dates, or use in date calculations.
To view a date serial number as a date, you must apply a date format to the cell. Find links to more information about displaying numbers as dates in the See Also section.
(DATEVALUE() Excel 函数的实现。语法:DATEVALUE(date_text) DATEVALUE 函数将存储为文本的日期转换为 Excel 识别为日期的序列号。例如,公式 =DATEVALUE("1/1/2008") 返回 39448,即日期 1/1/2008 的序列号。但请记住,您的计算机的系统日期设置可能会导致 DATEVALUE 函数的结果与此示例不同 如果工作表包含您想要过滤、排序或格式化为的文本格式的日期,DATEVALUE 函数很有帮助日期,或用于日期计算。要将日期序列号作为日期查看,您必须将日期格式应用于单元格。在另请参阅部分中查找有关将数字显示为日期的更多信息的链接。)Constructor and Description |
---|
DateValue() |
Modifier and Type | Method and Description |
---|---|
ValueEval |
evaluate(int srcRowIndex, int srcColumnIndex, ValueEval dateTextArg)
see
Function.evaluate(ValueEval[], int, int)
(见 Function.evaluate(ValueEval[], int, int))
|
evaluate
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval dateTextArg)
Function1Arg
Function.evaluate(ValueEval[], int, int)
(见 Function.evaluate(ValueEval[], int, int))
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.