Formula (Extended): $WEEKDAY Function

2023-12-062024-06-07

Overview¶

Find the day of the week corresponding to a date.

$WEEKDAY(Date,[Weekly Basis])

Parameter	Type	Required	Description
Date	Date or date string in yyyy/mm/dd format	Required
[Weekly Basis]	Half-width numeric value between 1 and 3 and 11 and 17	Optional	Determine the range of the return value according to the value set. If omitted, 1 is assumed to be set. 1: Return an integer in the range 1 (Sunday) to 7 (Saturday) 2: Return an integer in the range 1 (Monday) to 7 (Sunday) 3: Return an integer in the range 0 (Monday) to 6 (Sunday) 11: Return an integer in the range 1 (Monday) to 7 (Sunday) 12: Return an integer in the range 1 (Tuesday) to 7 (Monday) 13: Return an integer in the range 1 (Wednesday) to 7 (Tuesday) 14: Return an integer in the range 1 (Thursday) to 7 (Wednesday) 15: Return an integer in the range 1 (Friday) to 7 (Thursday) 16: Return an integer in the range 1 (Saturday) to 7 (Friday) 17: Return an integer in the range 1 (Sunday) to 7 (Saturday)

Parameter	Classification	Numeric Value	Date	Description	Check
Date	Yes	No	Yes	Yes	No
[Weekly Basis]	Yes	Yes	No	Yes	No

An integer in the range of 1 to 7 or 0 to 6.

Target	Display Content of Return Value
Classification (including title, status, manager, owner)	Display return value. In the case of a drop-down list with values, the options that match the return value are displayed.
Numeric Value (including work volume, progression rate, remaining work volume)	Display return value
Date (including start, completion)	Do not display
Description (including content)	Display return value
Check (including lock)	Do not display

Specify the parameter by screen column name (name displayed).

Specify parameters by screen item name (name displayed). The parameter [Weekly Basis] is also specified.