EOMONTH (PQL - xl)

This function calculates the date for the last day of the month (end of month) that is the indicated number of months before or after the starting 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

EOMONTH(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 'EOMONTH' function - using the same inputs, logic and outputs.