Function Date returns the DATE Value when we combine take 3 separate values to form a date.
Date Function in Excel
Syntax of DATE function in Excel
DATE(year,month,day)
Date Function Example:
When you’ve Year, Day, Month as seen in the above worksheet Year as 2016, Day as 18th and Month as 5.
Function =DATE(G5,I5,H5) will give you the output of the exact date = 5/18/2016
Year = Should be between 1900 to 9999
If year value is less than 1900 then Excel calculates the year by adding number to 1900
Example: –
DATE(200,11,20) returns a value of November 20, 2100 (1900 + 200)
Month = Month should be between 1 to 12, Excel adds any number be to the month
Example: –
DATE (2015, 13, 5) would return January 5, 2016 (13 = 12+1 Month i.e January)
If DATE(2015, -2, 5) would return October 5, 2015 (10 = 12-2 Month i.e October)