This function calculates a number that is equal to the Excel DATEVALUE function. For example, the formula = EXCELDATETIMESERIAL ( 2008 , 1 , 1 , 0 , 0 , 0 ) returns 39448, the serial number of the date 1/1/2008.
This can be useful if you need to calculate the time span between dates or add a time span to a date.
Sample model: datetimefunctions.mdl