Description

The PROJECTENDDATE function returns the end date of a project.

Syntax

PROJECTENDDATE(Connection, Project)

The PROJECTENDDATE function uses the following parameters:

Parameter

Required/Optional

Description

Connection

Required

The name of the connection as configured in the Connection Manager

Project

Optional

The Project to include

Example

=PROJECTENDDATE("Demo", "01SUPPORT")

Description

Returns the end date of the 01SUPPORT project.

Result

41670

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

Did this answer your question?