SI.PERIODENDDATE
Overview
The SI.PERIODENDDATE function returns the start date of the specified reporting period.
Syntax
CODE
=SI.PERIODENDDATE(Connection, ReportingPeriodName)Arguments
The SI. PERIODENDDATE function uses the following arguments:
Argument | Required/Optional | Description |
| Required | The name of the connection as configured in the Connection Manager |
| Optional | The name of the reporting period(s) for which we want to determine the ending date |
Examples
Example #1
CODE
=SI.PERIODENDDATE("Sage", A2)
Description
Returns the ending date for the reporting period listed in cell A2
Results
Example #2
CODE
=SI.PERIODENDDATE("Sage", A2#)
Description
Returns the ending date for each of the reporting periods listed by the array function in cell A2.
Results
