---
title: EDATE
description: Learn how to use the EDATE function to add or subtract months from a date. Helps adjust dates with precision.
---
import { Aside, Steps } from '@astrojs/starlight/components';

# EDATE

The EDATE function is used to add or subtract a specified number of months to a given date.

## Applicable to

Calculated Columns

## Return Value

The return value of the EDATE function is a date value representing the result of the calculation.

## Remark

* The `months` argument can be positive to add months to the `@StartDate`, or negative to subtract months from the `@StartDate`.
* The `months` argument can be a whole number or a column reference containing a number.
* The EDATE function is useful for calculating future or past dates based on a given date, and it is commonly used in financial and accounting scenarios for date calculations.
* The decimal number in the month argument will be rounded to the nearest whole number.

## Syntax

```
EADTE(<expression>, month)
```

<div style="padding: 10px; border: 2px solid grey; background: beige;"><code>EADTE(&lt;expression&gt;, month)</code></div>

<Aside type="tip">
You can call in the system defined date function start date and end date as `@StartDate` and `@StartDate` respectively.
</Aside>

## EDATE in Calculated Columns



| Expression | The start date of the period to which you want to add or subtract months. |
|---|---|
| Month | Number of months you want to add (if positive) or subtract (if negative) from the start date. |

Steps to use EDATE in Calculated Columns

<Steps>
1. Write the EDATE function. For instance ```EDATE(<expression>, month)```
2. Replace `<expression>` with the start period. You can also call in `@StartDate` function.
3. Replace `month` with the month value required.
4. To learn how to add calculated columns in Infoveave, visit the section [Calculated Columns](/studio-v8/datasources/calculated-columns-datasource/).
</Steps>

**Example** Suppose you want to create a column that returns the day based on the date column START DATE, you can use the WEEKDAY function as follows

```
WEEKDAY(DATEVALUE(VALUE([Start Date])))
```