1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel DATE Function

Add the Date to an Excel Worksheet

By

Excel's DATE Function

Excel's DATE Function

© Ted French

The DATE function uses include:

  • It can be used to combine date elements from different locations.
  • It can be used to convert dates to the computer's serial date.
  • It can be used to ensure that dates used in calculations are entered correctly into a cell - to ensure they are treated as a date or a number instead of text.


The syntax for the DATE function is:

= DATE( Year, Month, Day)

Year - enter the year as a four digit number (yyyy) or the cell reference where it is located.

Month - enter the month (mm) as a two digit number or the cell reference where it is located.

Day - enter the day as a two digit number (dd) or the cell reference where it is located.

Example Using Excel's DATE Function:

Note: To get the DATE function to return the computer's serial date, format the cell E1 as Number before entering the function.

  1. Enter the following data into cells D1 to D3: 2008 , 2 , 24.

  2. Click on cell E1 - the location where the results will be displayed.

  3. Click on the Formulas tab.

  4. Choose Date & Time from the ribbon to open the function drop down list.

  5. Click on DATE in the list to bring up the function's dialog box.

  6. Click on the "Year" line in the dialog box.

  7. Click on cell D1 to enter the cell reference into the dialog box.

  8. Click on the "Month" line in the dialog box.

  9. Click on cell D2 to enter the cell reference.

  10. Click on the "Day" line in the dialog box.

  11. Click on cell D3 to enter the cell reference.

  12. Click OK.

  13. The current date should appear in cell E1 in the format 2/24/2008.

  14. When you click on cell E1 the complete function = DATE( Year, Month, Day) appears in the formula bar above the worksheet.

©2014 About.com. All rights reserved.