DAYSOFMONTH- FineBI Document

Last update： 2022-04-04

1. Extracted data

Syntax	DAYSOFMONTH(date)	Returns the number of days in a month in a year since January 1900.
Parameter	date	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

1）Overview

Syntax

DAYSOFMONTH(date)

Returns the number of days in a month in a year since January 1900.

Parameter

date

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

Formula	Result	Remark
DAYSOFMONTH("1900-02-01")	28

中文（简体）中文（繁體）日本語

English