|
EXCELDATESERIAL_xxx functions EXCELDATESERIAL_YEAR ( Excel date code ) EXCELDATESERIAL_MONTH_OF_YEAR ( Excel date code ) EXCELDATESERIAL_DAY ( Excel date code ) EXCELDATESERIAL_DAY_OF_MONTH ( Excel date code ) EXCELDATESERIAL_DAY_OF_YEAR ( Excel date code ) EXCELDATESERIAL_WEEK_OF_YEAR ( Excel date code ) |
Scroll Prev Top Next More |
These functions are used to retrieve the components of an Excel date/time number.
For example, the formula TEST TIME = EXCELDATESERIAL ( 2008 , 1 , 1 ) returns 39448, the serial number of the date 1/1/2008.
TEST YEAR = EXCELDATESERIAL_YEAR ( 39448 ) will return 2008
TEST MONTH = EXCELDATESERIAL_MONTH ( 39448 ) will return 1
TEST DAY = EXCELDATESERIAL_DAY_OF_MONTH ( 39448 ) will return 1
Sample model: datetimefunctions.mdl
