<< Click to Display Table of Contents >> DAYSP (compatibility function)

Syntax:

DAYSP(StartDate, EndDate)

Description:

Compatibility function for older PlanMaker documents.

This function has been replaced by the DAYS function. (Please note that the order of the parameters is reversed.)

See the notes below.

Note:

DAYSP is merely a compatibility function. When you open a document created with PlanMaker 2012 or earlier, all occurrences of the DAYS function are automatically converted into DAYSP. Reason: In PlanMaker 2016, the order of the parameters for the DAYS function was reversed.

For new documents, we recommend that you use the DAYS function (compatible with Excel 2013), which is identical – except for the order of its parameters:

DAYS(EndDate, StartDate) equals

DAYSP(StartDate, EndDate)

For more information, see DAYS.

Compatibility notes:

This function does not exist in Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced with their current result as a fixed value.

Example:

DAYSP("01/01/2018", "01/14/2018") returns 13

If cell A1 contains the date value 01/01/2018 and cell A2 contains the date value 01/14/2018:

DAYSP(A1, A2) returns 13

See also:

DAYS, DATEDIF, NETWORKDAYS, DAYS360, TIMEDIFF