Date Function in Excel = Date(year,month,day)

Date Function in Excel

The Excel date function is built directly into Excel. You can use this function in a variety of useful ways.


Year – The year when creating the date

Month – The month for creating the date

Day – The day to use when creating the date

date function

When the above function is executed, it will produce the following results.

date function

*Years cannot being before 1900.

*Months can only be 1-12

*Day are related to the month. For example, if you pick June 31, Excel will change the date to July 1.

Was this article helpful?

Related Articles

Leave a Reply