Description
The FINANCIALPERIODENDDATE function returns the Excel date value for the end date of a financial period.
Syntax
FINANCIALPERIODENDDATE(Connection, Period)
Parameters
The FINANCIALPERIODENDDATE function uses the following parameters (see our articles on including multiple parameter values and using arrays or cell ranges as parameters):
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection, as specified in the Connection Manager |
Period | Required | The financial period, in MM-YYYY format. |
Example
=FINANCIALPERIODENDDATE("Demo", "12-2014")Description: Returns the end date of 12-2014 financial period.
Result: 42004 (The Excel value for December 31, 2014)
Applies to
GL Module