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

Did this answer your question?