Description
The PROJECTTASKSTARTDATE function returns the start date of a project task.
Syntax
PROJECTTASKSTARTDATE(Connection, Project, ProjectTask)
The PROJECTTASKSTARTDATE function uses the following parameters (see our article on including multiple parameter values):
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
Project | Required | The Project(s) to include |
ProjectTask | Required | The ID(s) of the Task(s) to include |
Example
=PROJECTTASKSTARTDATE("Demo","FIXEDP01", "01TASK")Description
Returns the start date of 01TASK task of the FIXEDP01 project.
Result
41456
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