Fresh Excel Tips

In this example, we have three Columns that list the Year, Month (Numbers from 1-12) and Days (1-31) in columns A, B and C. The aim of this exercise is to combine all 3 values to show one formatted date. To do so, we will need to utilize the DATE function. Here is the syntax that is used:

DATE(year, month, day)
year: This argument can be from one to four digits. Microsoft Excel for Windows uses the 1900 date system.
month: A number representing the month of the year (1 to 12).
day: A number representing the day of the month (1 to 31).

Here is how we’ll use the DATE Function to achieve our aim

How to Combine values of cells into one date

1. Enter your data as shown below or modify it to suit your needs
2. Select cell D2 and type the following formula: =DATE(A2,B2,C2).
3. Use the fill handle to copy the formula as needed.

This tip should work in Microsoft Excel 97, 2000, 2003 and 2007. Thanks for reading.

1. Combine Cells with text, date, time and numbers in Excel
2. Use the LEFT, MID, and RIGHT functions to extract date parts
3. How to use the TEXT function to extract parts of a date in Excel
4. How to add months to a date using the DATE Function in Excel
5. How to Use the YEAR function to extract the year part of a date