---
title: "Use the YEAR Function to Extract the Year from a Given Date"
slug: "year-function"
description: "Learn to apply the YEAR function to return the calendar year from a given Date, useful for reporting and time-based logic."
updated: 2025-05-30T09:43:48Z
published: 2025-08-22T11:59:25Z
canonical: "kb.pigment.com/year-function"
---
> ## 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.
# YEAR function
## Description
Returns the year of the given Date.
## Syntax
`YEAR(Date)`
## Arguments
| Argument | Type | Dimensions | Description |
| --- | --- | --- | --- |
| *Date* (required) | Date | Any Dimensions | Date to get the year from. |
## Returns
| Type | Dimensions |
| --- | --- |
| Integer | Dimensions of argument *Date* |
## Examples
| Formula | Result | Description |
| --- | --- | --- |
| `YEAR(DATE(2020, 12, 02))` | 2020 | The date December 2nd 2020 has a year of 2020. |
## See also
Excel: [YEAR](https://support.microsoft.com/en-us/office/year-function-c64f017a-1354-490d-981f-578e8ec8d3b9)
Related articles: [MONTH](/v1/docs/month-function), [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!