反馈已提交

网络繁忙

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

WEEKDATE

  • Recent Updates: April 04, 2022

    • 1. Overview

    SyntaxWEEKDATE(year,month,weekOfMonth,dayOfWeek)Returns the specific day of the week in the specified week of the specified month.
    Parameter1yearYear
    Parameter2monthMonth
    Parameter3weekOfMonthThe specified week of the month
    Parameter4dayOfWeekReturns the specific day of the week in the specified week of the specified month.

    2. Precautions

    • Extracted data supports setting four numeric or text parameters.

    • Real-time data supports using four numeric parameters.

    3. Example

    FormulaResultRemark
    WEEKDATE(2009,10,2,1)2009-10-04The return date is the first day of the second week of October 2009.
    WEEKDATE(2009,12,1,-1)2009-12-05

    The return date is the Saturday of the first week of December 2009.


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