---
title: "Use the EDATE Function to Add or Subtract Months from a Date"
slug: "edate-function"
description: "Learn to use the EDATE function to add or subtract months from a date value and manage time-based calculations in Pigment."
updated: 2025-05-30T09:43:50Z
published: 2025-08-22T11:59:25Z
---
> ## 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.
# EDATE function
## Description
Adds or substracts a given number of months to the given Date.
## Syntax
`EDATE(Date [, Month Offset])`
## Arguments
| Argument | Type | Dimensions | Description |
| --- | --- | --- | --- |
| *Date* (required) | Date | Any Dimensions | Date to add or substract. |
| *Month Offset* (required) | Integer | No Dimension or Dimensions of argument *Date* | Offset the given argument *Date* by a number of months. By default, the offset is equivalent to 0. |
## Returns
| Type | Dimensions |
| --- | --- |
| Date | Dimensions of argument *Date* |
If a corresponding day does not exist in the target month, the last day of the month will be used instead.
## Examples
| Formula | Result | Description |
| --- | --- | --- |
| `EDATE(DATE(2020, 12, 02), 2)` | February 2nd 2021 | Two months added to December 2nd 2020 is February 2nd 2021. |
| `EDATE(DATE(2020, 12, 30), 2)` | February 28th 2021 | Two months added to December 30th 2020 is February 28th 2021. February 30th does not exist, so the last day of the month is used instead. |
## See also
Excel: [EDATE](https://support.microsoft.com/en-us/office/edate-function-3c920eb2-6e66-44e7-a1f5-753ae47ee4f5)
Related articles: [DATE](/v1/docs/date-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!