反馈已提交

网络繁忙

You are viewing 5.1 help doc. More details are displayed in the latest help doc.

DAYS360

  • Recent Updates: April 08, 2022

    • 1. Overview

    SyntaxDAYS360(start_date,end_date,method)Using a 360-day year algorithm (30 days per month for a 12-month year), return the number of days that differ between the two days, which will be used in accounting calculations. If the financial system is based on 12 months of the year, 30 days per month, use this function to help calculate payments.
    Parameter1start_date

    start_date and end_date: used to calculate the number of days of the start and end dates in a period. 

    Parameter2end_date
    Parameter3methodIt specifies whether European or American methods are used in the calculation. Method definition :FALSE or empty is the American Method (NASD). TRUE is a European method. That is, either the 31st of a month from the start date or the 31st of a month from the end date is equal to the 30th of the month.

    2. Precautions

    • Real-time data is not supported

    • Supports three parameters. The third parameter can be default. The previous two parameters are date or text, and the third parameter is text or value.

    • Parameter true(TURE), false (FALSE), and case are supported, and case is marked with blue.

    3. Example

    FormulaResultRemark
    DAYS360("1998/1/30","1998/2/1")1


    Attachment List


    Theme： Advanced Data Analyis
    Already the First
    Already the Last
    • Helpful
    • Not helpful
    • Only read

    售前咨询电话

    400-811-8890转1

    在线技术支持

    在线QQ：800049425

    热线电话：400-811-8890转2

    总裁办24H投诉

    热线电话：173-1278-1526

    文 档反 馈

    鼠标选中内容，快速反馈问题

    鼠标选中存在疑惑的内容，即可快速反馈问题，我们将会跟进处理。

    不再提示

    10s后关闭