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