Excel, Date() Function
The Date() function can be used to specify a date value in a cell.
Jump To:
You can download the file for this article here.
Contents
Syntax:
=Date(Year, Month, Day)
Year: The year value of the date (i.e 1999)
Month: The month value of the date in numeric format
Day: The day value of the date.
Example 1:
=DATE(1989,3, 4)
Result:
Example 2:
Note the year could also be specified as a 2 digit number:
=DATE(89,3, 4)
Result:
Example 3:
Using a 3 digit number for the year would result in a date in the year 2000+:
=DATE(110,3, 4)
Result:
Example 4:
In the example below the user enters the day, month and year of the date in columns A, B and C. The Date() function in column D gets those values as input and returns the associated date:
Result:
You can download the file for this article here.
See also:
If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my website www.software-solutions-online.com
2 thoughts on “Excel, Date() Function”