Description
The PROJECTENDDATE function returns the end date of a project.
Syntax
PROJECTENDDATE(Connection, Project)
The PROJECTENDDATE function uses the following parameters:
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
Project | Optional | The Project ID to include |
Example
=PROJECTENDDATE("Demo", "01SUPPORT")Description
Returns the end date of the 01SUPPORT project.
Result
41670
Note that 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. |
Applies to
PM Module