SI.PROJECTENDDATE
Overview
The SI.PROJECTENDDATE function returns the ending date for the specified project (in culture-neutral date format).
Syntax
=SI.PROJECTENDDATE(Connection, Project)
Arguments
The SI. PROJECTENDDATE function uses the following arguments:
Argument | Required/Optional | Description |
| Required | The name of the connection as configured in the Connection Manager |
| Required | The ID for the project for which the end date is to be retrieved. |
Examples
Example 1
=SI.PROJECTENDDATE("Sage", "10000")
Description
Returns the ending date for project 10000.
Results

Example 2
=SI.PROJECTENDDATE("Sage", C1#)
Description
Returns the ending date for each project displayed by the array function in cell C1.
Results

Example 3
=SI.PROJECTENDDATE("Sage", C1:C20)
Description
Returns the ending date for each project displayed in cells C1 through C20.
Results
