WEEKDAY - Returning the Weekday Number- FineDataLink Help Document

Last update: May 21, 2025

Overview

Syntax	WEEKDAY(text/date)	Gets the date and returns the corresponding weekday number.Returns an integer, ranging from 0 (Sunday) to 6 (Saturday).
Parameter	Serial_number	Represents the date entered. Despite the text and date types, the parameter can also be a serial number in the 1900 date system for extracted data. For example, 35796 represents 1998-01-01. The parameter can only be of the date or text type for real-time data.
Type of the Returned Value	Value

Syntax

WEEKDAY(text/date)

Gets the date and returns the corresponding weekday number.Returns an integer, ranging from 0 (Sunday) to 6 (Saturday).

Parameter

Serial_number

Represents the date entered.

Despite the text and date types, the parameter can also be a serial number in the 1900 date system for extracted data. For example, 35796 represents 1998-01-01.

The parameter can only be of the date or text type for real-time data.

Type of the Returned Value

Value

Usage Position

For details, see New Calculation Column.

Example:

Notes

If any parameter is NULL, the result is NULL.

Example

Formula	Result	Note
WEEKDAY("2005/9/10")	6	(Saturday)
WEEKDAY("2005/9/11")	0	(Sunday)

Helpful
Not helpful
Only read

中文（简体）

English

WEEKDAY - Returning the Weekday Number

Overview

Usage Position

Notes

Example

附件列表