DATEVALUE

Converts the value of an internal date to the Excel date value (equal to the number of days since 1/1/1900).

Formula Syntax

DATEVALUE(Date)

Date: system date such as CALCDATE, DOH, or a Derived Date of the Plan Document.

Examples

DATE(1,1,2017) will return the amount 42736

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com