PROJECTTASKPLANNEDENDDATE
Overview
The PROJECTTASKPLANNEDENDDATE function returns the planned end date of a project task.
Syntax
CODE
=PROJECTTASKPLANNEDENDDATE(Connection, Project, ProjectTask)Arguments
The PROJECTTASKPLANNEDENDDATE function uses the following arguments:
Argument | Required/Optional | Description |
| Required | The name of the connection as configured in the Connection Manager |
| Required | The ID of the Project to include |
| Required | The ID of the Task to include |
Example
CODE
=PROJECTTASKPLANNEDENDDATE("Demo", "INTERNAL14", "03SOFTWARE")Description
Returns the planned end date of the 03SOFTWARE task in the INTERNAL14 project.
Result
42004
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.