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)
|
ValueEval |
evaluate(int srcRowIndex,
int srcColumnIndex,
ValueEval arg0,
ValueEval arg1,
ValueEval arg2)
|
ValueEval |
evaluate(ValueEval[] args,
int srcRowIndex,
int srcColumnIndex) |
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1)
Function2Arg
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
Function3Arg
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
.srcRowIndex
- row index of the cell containing the formula under evaluationsrcColumnIndex
- column index of the cell containing the formula under evaluationErrorEval
, 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
.Copyright 2022 The Apache Software Foundation or its licensors, as applicable.