---
title: "Use the DAY Function to Extract the Day from a Given Date"
slug: "day-function"
description: "Learn to apply the DAY function to return the calendar day from a given Date, useful for reporting and time-based logic."
tags: ["DAY", "formula syntax", "functions ", "Modeling and Formulas", "Pigment Blocks", "Pigment Boards"]
updated: 2025-10-10T17:52:42Z
published: 2025-10-10T17:52:42Z
---

> ## 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.

# DAY function

## Description

Returns the day of the given Date.

## Syntax

`DAY(Date)`

## Arguments

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

## Returns

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

## Examples

| Formula | Result | Description |
| --- | --- | --- |
| `DAY(DATE(2020, 12, 02))` | 2 | The date December 2th 2020 has a day of 2. |

## See also

Excel: [DAY](https://support.microsoft.com/en-us/office/day-function-8a7d1cbb-6c7d-4ba1-8aea-25c134d03101)

Related articles: [MONTH](/v1/docs/month-function), [YEAR](/v1/docs/year-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!