反馈已提交

网络繁忙

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

DAYSOFMONTH

  • Recent Updates: April 04, 2022
  • 1. Extracted data

    SyntaxDAYSOFMONTH(date)Returns the number of days in a month in a year since January 1900.
    Parameterdate

    In addition to supporting text and date types, date can also be a series of numbers. For example, in the 1900 date system, January 1, 1998 is stored as a series of 35796.

    2)Precaution

    • Supports a date or text type parameter, if more than one parameter, that is invalid.

    3)Example

    FormulaResultRemark
    DAYSOFMONTH("1900-02-01")28
    DAYSOFMONTH("2008/04/04")30
    DAYSOFMONTH(35796)31

    2. Real-time data

    1)Overview

    SyntaxDAYSOFMONTH(date)Returns the number of days in a month in a year since January 1900.
    Parameterdate

    date supports only text and date types.


    2)Precaution

    • Supports a date or text type parameter, if more than one parameter, that is invalid.

    3)Example

    FormulaResultRemark
    DAYSOFMONTH("1900-02-01")28


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