> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# Weekday

The **Weekday** function evaluates a specified date and returns an integer representing the day of the week (with `1` representing Sunday, `2` representing Monday, `3` representing Tuesday, and so on).

## Syntax

```
Weekday(date, [timezone])
```

Function arguments:

* **date** (required) - the date or column containing date values from which the weekday is determined
* **timezone** (optional) - the [IANA time zone](https://en.wikipedia.org/wiki/List_of_tz_database_time_zones) (e.g., “America/Los\_Angeles”) to convert the date value to before evaluating the weekday

## Example

```
Weekday(Date("2017-12-01"))
```

Evaluates the specified date (December 1, 2017) to determine the day of the week and returns `6` to represent Friday, the sixth day of the week.

## Related resources

* [DatePart](/docs/datepart)
* <a href="https://quickstarts.sigmacomputing.com/guide/common_date_functions/index.html" target="_blank" rel="noopener noreferrer">
    Sigma Quickstart: Common date functions and use cases
  </a>