Skip to main content
Skip table of contents

PROJECTTASKPLANNEDSTARTDATE

Overview

The PROJECTTASKPLANNEDSTARTDATE function returns the planned start date of a project task.

Syntax

CODE
=PROJECTTASKPLANNEDSTARTDATE(Connection, Project, ProjectTask)

Arguments

The PROJECTTASKPLANNEDSTARTDATE 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 Project to include

ProjectTask

Required

The ID of the Task to include

Example

CODE
=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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.