反馈已提交

网络繁忙

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

DATEDELTA

  • Recent Updates: April 04, 2022

    • 1. Extracted data

    1）Overview

    SyntaxDATEDELTA(date,deltadays)Return a deltadays after date.
    Parameter1date

    In addition to text and date types, date also supports the 1900 series number, for example, 35796 is 1998-01-01.

    Parameter2deltaDaysIt could be positive, negative, zero.

    2）Precaution

    • Supports two parameters, the first a date or text type parameter and the second a numeric value

    3）Example

    FormulaResultRemark
    DATEDELTA("2008-08-08",-10)2008-07-29
    DATEDELTA("2008-08-08",10)2008-08-18
    DATEDELTA(35796,10)1998-01-11

    2. Real-time data

    1）Overview

    SyntaxDATEDELTA(date,deltadays)Return a deltadays after date.
    Parameter1date

    Support only text and date types.

    Parameter2deltadaysIt could be positive, negative, zero.

    2）Precaution

    • Supports two parameters, the first of which is a date or text type and the second of a numeric type.

    3）Example

    FormulaResultRemark
    DATEDELTA("2008-08-08",-10)2008-07-29
    DATEDELTA("2008-08-08",10)2008-08-18


    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后关闭