DATE Function in Excel

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

 =Date(year,month,day) 
  • 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 2

Some characteristics to note:

  • *Years cannot begin before 1900.
  • *Months can only be 1-12
  • *Days are related to the month. For example, if you pick June 31, Excel will change the date to July 1.

Leave a Reply

Randomly Sort Data in Excel

Learn to randomly sort data in Excel by using this simple trick. The RAND Function can be used to randomly sort a data set by applying a numerical number.

Read More »

DATEDIF Function

The DATEDIF Function in Excel is used to calculate the number of days, months, or years between two dates. A

Read More »
Scroll to Top