PROJECTENDDATE
Overview
The PROJECTENDDATE function returns the end date of a project.
Syntax
CODE
=PROJECTENDDATE(Connection, Project)Arguments
The PROJECTENDDATE function uses the following arguments:
Argument | Required/Optional | Description |
| Required | The name of the connection as configured in the Connection Manager |
| Optional | The Project ID to include |
Example
CODE
=PROJECTENDDATE("Demo", "01SUPPORT")Description
Returns the end date of the 01SUPPORT project.
Result
41670
The results are returned as a serial number - to match Excel's default treatment for dates. The cell can be formatted to any date format desired.