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)

EADTE(<expression>, month)

Tip

You can call in the system defined date function start date and end date as @StartDate and @StartDate respectively.

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

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.

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])))