Manuals/calci/DAYS360

DAYS360(startdate,enddate,method)

• $startdate$ is the date from which date counting have to start.
• $enddate$ is the ending date of the counting.
• $method$ is the logical value either true or false.

Description

• This function gives the number of days between given dates based on 360 days in a year. (30 days in 12 months).
• Here $startdate$ and $enddate$are the two dates to find the in between days.
• $method$ is the logical value like TRUE or FALSE.
• When logical value is true, then the result is based on U.S.method.
• when logical value is false, then the result is based on the European method .
• when we are not giving any logical values it will consider the U.S method.
• This function will give result as NAN, when the end date is before the starting date.

ZOS

• The syntax is to calculate DAYS360 in ZOS is $DAYS360(startdate,enddate,method)$.
• $startdate$ is the date from which date counting have to start.
• $enddate$ is the ending date of the counting.
• $method$ is the logical value either true or false.
• For e.g.,DAYS360("10/30/2010","6/15/2016",TRUE) = 2025.

Days360

Examples

• DAYS360("12/13/2013","1/13/2014",TRUE)=30
• DAYS360("2/20/2013","3/3/2013",FALSE)= 13

Related Videos

DAYS360

See Also

• DATE
• DAY

References

• 360 DAYS