SI.PROJECTENDDATE
Overview
The SI.PROJECTENDDATE function returns the ending date for the specified project (in culture-neutral date format).
Syntax
CODE
=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
CODE
=SI.PROJECTENDDATE("Sage", "10000")
Description
Returns the ending date for project 10000.
Results
Example 2
CODE
=SI.PROJECTENDDATE("Sage", C1#)
Description
Returns the ending date for each project displayed by the array function in cell C1.
Results
Example 3
CODE
=SI.PROJECTENDDATE("Sage", C1:C20)
Description
Returns the ending date for each project displayed in cells C1 through C20.
Results
