Please enable JavaScript to view this site.

Vensim Help

Navigation: Reference Guide > Functions > Date/time functions

EXCELDATETIMESERIAL ( year , month , day , hour , minute , second )

Scroll Prev Top Next More

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