@CalcMgrExcel Custom Functions with Date Parameters
Date parameters used in @CalcMgrExcel
functions must be in an Excel format. You can use these functions to convert dates from a YYYYMMDD
format (serial format) to an Excel format:
-
@CalcMgrExcelDATE
returns the serial number of a particular date.The following example converts
20181214
(YYYYMMDD
format) to an Excel date@CalcMgrExcelDATE(20181214)
-
@CalcMgrDateToExcel
converts a single date inYYYYMMDD
format to an Excel date -
@CalcMgrDatesToExcel
converts multiple dates inYYYYMMDD
format to Excel datesIn the following example:
@CalcMgrDatesToExcel(@LIST("Jan"->"Date_123", "Feb"->Date_123)
"Jan"->"Date_123"
will display as01/31/19
and"Feb"->Date_123
will display as02/31/19