public class Days360
extends java.lang.Object
Calculates the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. Use this function to help compute payments if your accounting system is based on twelve 30-day months.
DAYS360(start_date,end_date,[method])
=DAYS360("2/28/93", "3/1/93", FALSE)
returns 1 day because the DAYS360 function ignores the extra days added to February.=DAYS360("2/29/96","3/1/96", FALSE)
returns 1 day for the same reason.=DAYS360("2/28/93", "3/1/93", TRUE)
returns 3 days because the DAYS360 function is counting the extra days added to February to give February 30 days.=DAYS360("2/29/96", "3/1/96", TRUE)
returns 2 days for the same reason.Constructor and Description |
---|
Days360() |
Modifier and Type | Method and Description |
---|---|
ValueEval |
evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
see
Function.evaluate(ValueEval[], int, int)
(见 Function.evaluate(ValueEval[], int, int))
|
ValueEval |
evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
see
Function.evaluate(ValueEval[], int, int)
(见 Function.evaluate(ValueEval[], int, int))
|
ValueEval |
evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex) |
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
Function2Arg
Function.evaluate(ValueEval[], int, int)
(见 Function.evaluate(ValueEval[], int, int))
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
Function3Arg
Function.evaluate(ValueEval[], int, int)
(见 Function.evaluate(ValueEval[], int, int))
public final ValueEval evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
evaluate
in interface
Function
(在接口函数中求值)
args
- the evaluated function arguments. Empty values are represented with
BlankEval
or
MissingArgEval
, never
null
.
(args - 评估的函数参数。空值用 BlankEval 或 MissingArgEval 表示,绝不为 null。)
srcRowIndex
- row index of the cell containing the formula under evaluation
(srcRowIndex - 包含计算公式的单元格的行索引)
srcColumnIndex
- column index of the cell containing the formula under evaluation
(srcColumnIndex - 包含正在评估的公式的单元格的列索引)
ErrorEval
, never
null
.
Note - Excel uses the error code
#NUM! instead of IEEE
NaN, so when numeric functions evaluate to
Double.NaN
be sure to translate the result to
ErrorEval.NUM_ERROR
.
(评估结果,可能是 ErrorEval,绝不为空。注意 - Excel 使用错误代码 #NUM!而不是 IEEE NaN,因此当数值函数计算为 Double.NaN 时,请务必将结果转换为 ErrorEval.NUM_ERROR。)
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.