## Overview Find the day of the week corresponding to a date. ## Syntax ``` $WEEKDAY(Date,[Weekly Basis]) ``` ## Parameters |Parameter|Type|Required|Description| |:---|:---|:---|:---| |Date|Date or date string in yyyy/mm/dd format|Required|| |[Weekly Basis]|Half-width numerical 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. <br>1: Return an integer in the range 1 (Sunday) to 7 (Saturday)<br>2: Return an integer in the range 1 (Monday) to 7 (Sunday)<br>3: Return an integer in the range 0 (Monday) to 6 (Sunday)<br>11: Return an integer in the range 1 (Monday) to 7 (Sunday)<br>12: Return an integer in the range 1 (Tuesday) to 7 (Monday)<br>13: Return an integer in the range 1 (Wednesday) to 7 (Tuesday)<br>14: Return an integer in the range 1 (Thursday) to 7 (Wednesday)<br>15: Return an integer in the range 1 (Friday) to 7 (Thursday)<br>16: Return an integer in the range 1 (Saturday) to 7 (Friday)<br>17: Return an integer in the range 1 (Sunday) to 7 (Saturday)| ### Column Usable as Parameters |Parameter|Classification|Numerical Value|Date|Description|Check| |:---|:---|:---|:---|:---|:---| |Date|Yes|No|Yes|Yes|No| |[Weekly Basis]|Yes|Yes|No|Yes|No| ## Return Value An integer in the range of 1 to 7 or 0 to 6. ### Return Value Display Content |Target|Display Content of Return Value| |:---|:---| |Classification (including title, status, manager, owner)|Display return value. In case of drop-down list with values, display options that match the return value| |Numerical 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| ## Usage Example ① Specify the parameter by screen column name (name displayed). ### Formula  ### Parameters  ### Calculation Result  ## Example of use ② Specify parameters by screen item name (name displayed). The parameter [Weekly Basis] is also specified. ### Formula  ### Parameters  ### Calculation Result