Formula Engine Reference Guide
 

 

Back to Class Index

 

DATE(Y, M, D)

Description
This function returns the date value corresponding to year Y+1900, month M, and date D. Y must be in the range 0 to 199 (representing 1900-2099).
 
Parameters
Y

year
 
M
month
 
D
day
 
Examples
DATE(66, 4, 6) = 24203, April 6, 1966
 
DATE(366) = Error! wrong number or arguments