PROJECTTASKENDDATE

Overview

The PROJECTTASKENDDATE function returns the end date of a project task.

CODE

=PROJECTTASKENDDATE(Connection, Project, ProjectTask)

The PROJECTTASKENDDATE function uses the following arguments:

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

CODE

=PROJECTTASKENDDATE("Demo","FIXEDP01", "01TASK")

Description

Returns the end date of the 01TASK task in project FIXEDP01.

Result

41470

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.