WEEKDAY- FineBI Document

Last update： 2022-04-04

1. Overview

Syntax	WEEKDAY(serial_number)	Gets the date and returns the number of weeks. The return value is an integer between 0 and 6, representing a day of the week (Sunday to Saturday).
Parameter	serial_number	Represents the date entered. In the extracted data: in addition to text and date type, the series number of 1900 is also supported, for example, 35796 is 1998-01-01. Real-time data: Supports only text and date types.

Syntax

WEEKDAY(serial_number)

Gets the date and returns the number of weeks. The return value is an integer between 0 and 6, representing a day of the week (Sunday to Saturday).

Parameter

serial_number

Represents the date entered.

In the extracted data: in addition to text and date type, the series number of 1900 is also supported, for example, 35796 is 1998-01-01.

Real-time data: Supports only text and date types.

Formula	Result	Remark
WEEKDAY("2005/9/10")	6	(Saturday) Note: The real-time data is not available in 2005/9/11 format, which needs to be changed to 2005-09-10 format.
WEEKDAY("2005/9/11")	0	(Sunday) Note: The real-time data is not available in 2005/9/11 format, which is used for the first time in 2005-09-10.
WEEKDAY(35796)	4	(Thursday) Real-time data does not support this notation.

Formula

Result

Remark

WEEKDAY("2005/9/10")

(Saturday) Note: The real-time data is not available in 2005/9/11 format, which needs to be changed to 2005-09-10 format.

WEEKDAY("2005/9/11")

(Sunday) Note: The real-time data is not available in 2005/9/11 format, which is used for the first time in 2005-09-10.

WEEKDAY(35796)

(Thursday)

Real-time data does not support this notation.

Previous：WEEK

Next：TODAY

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

English