PROJECTTASKPLANNEDENDDATE

Overview

The PROJECTTASKPLANNEDENDDATE function returns the planned end date of a project task.

CODE

=PROJECTTASKPLANNEDENDDATE(
    ConnectionName,
    Project,
    Task
)

The PROJECTTASKPLANNEDENDDATE function uses the following arguments:

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection as configured in the Connection Manager
`Project`	Required	The ID of the Project to include
`Task`	Required	The ID of the Task to include

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.