• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

DATE in Excel

September 12, 2021 by Andrew Childress
Date in Excel

As you work in spreadsheets, you’ll often find yourself using dates in formulas. Let’s learn how to use DATE in Microsoft Excel.

As you work in spreadsheets, you’ll often find yourself using dates in formulas. Sometimes, you may have key elements like the year, month, and day listed in separate cells. Fortunately, Excel makes it easy to combine these values into a single date. Let’s learn how to use DATE in Microsoft Excel.

How to Use DATE in Excel

Imagine that you have a spreadsheet with three columns: one lists months, one lists days, and one lists years. To process your data, you want to combine these values into a single, date-formatted cell. This is where Excel’s DATE function comes in. DATE recognizes these independent values and seamlessly combines them into a single cell with a full date.

To get started with DATE, you’ll need year, month, and date values numerically formatted like you see below. For example, April should be written as 4, not as “April,” “Apr,” or similar.

Date in Excel

Then, your next step is to click into any empty cell in your workbook. Type an = sign first. This tells Excel that you’re inputting a formula into the selected cell. Then, type DATE( to add your DATE function.

So far, your formula reads:

=DATE(

Now, Excel asks for three inputs: year, month, and day. To complete the formula, click into the first cell containing a year, then type a comma. Repeat for the month and day cells, then close your parentheses. Here, your complete formula is:

=DATE(C2,A2,B2)

Date function in Excel

Hit Enter on your keyboard, and Excel will return the combined date value. Notice also that your cell automatically reformats to Date format, making it easier to work with the data while preserving the date inside the cell.

Date formula in Excel

As you can see, Excel’s DATE function makes it easy to work with multiple cells containing date information. It’s an easy way to unify data and view dates quickly and easily.

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Hide zeroes in ExcelHide Zeroes in Excel
Next Post:Reduce File Size in ExcelReduce Excel file size

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top