SI.PERIODSTARTDATE
Overview
The SI.PERIODSTARTDATE function returns the start date of the specified reporting period.
Syntax
CODE
=SI.PERIODSTARTDATE(
ConnectionName,
ReportingPeriod
)Arguments
The SI. PERIODSTARTDATE 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 starting date |
Examples
Example #1
CODE
=SI.PERIODSTARTDATE(
"Sage",
A1
)
Description
Returns the starting date for the reporting period listed in cell A1.
Results
Example #2
CODE
=SI.PERIODSTARTDATE(
"Sage",
A2#
)
Description
Returns the starting date for each of the reporting periods listed by the array function in cell A2.
Results
