EDATE (PQL - xl)

This function calculates the date that is the indicated number of months before or after a specified date

  • Library: PQL \ Spreadsheet \ Date & Time
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
  • Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions

Syntax

EDATE(start date, months)

Function Arguments

Name

Description

Type

Optional

start date

Starting date

StringOrNumber

months

Number of months before (negative) or after (positive) the starting date; if not an integer, the number is truncated

Number

Comments

This function is the same as the Microsoft Excel 'EDATE' function - using the same inputs, logic and outputs.