WEEKDAY- FineBI Help Document FineBI Document

Recent Updates: April 04, 2022

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.

Already the First

Already the Last

售前咨询电话

400-811-8890转1

在线技术支持

在线QQ：800049425

热线电话：400-811-8890转2

总裁办24H投诉

热线电话：173-1278-1526

文档反馈

鼠标选中内容，快速反馈问题

鼠标选中存在疑惑的内容，即可快速反馈问题，我们将会跟进处理。

不再提示

10s后关闭