PROJECTSTARTDATE

Overview

The PROJECTSTARTDATE function returns the start date of a project.

CODE

=PROJECTSTARTDATE(
    ConnectionName,
    Project
)

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

CODE

=PROJECTSTARTDATE(
    "Demo",
    "X"
)

Description

Returns the start date of the X project.

Result

40544

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.