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)

Excel, Date Function
Result:

Excel Date Function, Result


Example 2:

Note the year could also be specified as a 2 digit number:

=DATE(89,3, 4)

Excel Date Function Example 2
Result:

Excel Date Function, Result


Example 3:

Using a 3 digit number for the year would result in a date in the year 2000+:

=DATE(110,3, 4)

Excel Date Function Example 3
Result:

Excel Date Function, Result 3


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:

Excel, Date Function, Example 4

Result:

Excel, Date Function, Example 4, 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”

Leave a Reply

Your email address will not be published. Required fields are marked *