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("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|
|Modifier and Type||Method and Description|
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)
args- the evaluated function arguments. Empty values are represented with
srcRowIndex- row index of the cell containing the formula under evaluation
srcColumnIndex- column index of the cell containing the formula under evaluation
null. Note - Excel uses the error code #NUM! instead of IEEE NaN, so when numeric functions evaluate to
Double.NaNbe sure to translate the result to
Copyright 2019 The Apache Software Foundation or its licensors, as applicable.