Manuals/calci/DAYS360

DAYS360(sd,ed,lv)

• $sd$ is the starting date
• $ed$ is the end date
• $lv$ is the logical value like true or false

Description

• This function gives the number of days between given dates based on 360 day year (30 days in 12 months).
• Here $sd$ and $ed$are the two dates to find the in between days.
• $lv$ 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.

Examples

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

See Also

• DATE
• DAYS