---
title: "Use the WEEKDAY Function to Return Day of the Week from Given Date"
slug: "weekday-function"
description: "Learn to use the WEEKDAY function to return the day of the week from a specified Date value in Pigment models."
updated: 2025-05-30T09:43:18Z
published: 2025-08-22T10:57:28Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# WEEKDAY function

## Description

Returns the day of the week of the given Date.

## Syntax

`WEEKDAY(Date)`

## Arguments

| Argument | Type | Dimensions | Description |
| --- | --- | --- | --- |
| *Date* (required) | Date | Any Dimensions | Date to get the weekday from. |

## Returns

| Type | Dimensions |
| --- | --- |
| Integer | Dimensions of argument *Date* |

## Examples

| Formula | Result | Description |
| --- | --- | --- |
| `WEEKDAY(DATE(2020, 12, 02))` | 3 | The date December 2nd 2020 is a Wednesday, the result is 3. |
| `WEEKDAY(DATE(2020, 12, 06))` | 0 | The date December 6th 2020 is a Sunday, the result is 0. |

## See also

Excel: [WEEKDAY](https://support.microsoft.com/en-us/office/weekday-function-60e44483-2ed1-439f-8bd0-e404c190949a)

Related articles: [DAY](/v1/docs/day-function)

> [!TIP]
> More of a hands-on learner?
> 
> Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!

<style> p[data-block-id] {font-size:1rem;} ul li p[data-block-id] {margin-bottom: 0;} ul[data-type="taskList"] li div p[data-block-id] {margin-bottom: 0;} ol li p[data-block-id] {margin-bottom: 0;} table tbody th p[data-block-id] { margin-bottom: 0;} blockquote p[data-block-id] {margin-bottom: 0 !important;} &nbsp;p[data-block-id]:empty::after {content: "\00A0";} </style>