Function Problems

Combine Day, Month, and Year Columns into an Excel Date

Elise WilliamsElise Williams Nov 18, 2026 871 views

Question details

Combine separate day, month, and year values into a real Excel date without changing the original columns.

Combine Day, Month, and Year Columns into an Excel Date
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet contains day, month, and year numbers in separate columns that must remain available to other worksheets.
Observed behavior
The desired result is a separate column containing usable Excel dates while the original columns remain unchanged.
Before you start

Identify the columns containing the day, month, and four-digit year, and choose an empty column for the result. The example below assumes the values are in A1, B1, and C1.

Solution 1Recommended

Use the DATE Function in a New Excel Column

Create a real Excel date in a separate column while keeping the source values available.

1
Enter the formula

Select cell D1 and enter =DATE(C1,B1,A1), then press Enter. DATE takes the year first, followed by the month and day.

2
Format the result

Select column D, open the Number Format list on the Home tab, and choose Short Date or Long Date.

3
Fill the remaining rows

Select D1 and drag its fill handle down alongside the remaining source rows. Adjust the formula references if your data starts in different columns or on a different row.

Use the DATE Function in a New Excel Column
Check the source values: DATE can adjust out-of-range month or day numbers rather than report an error. Check the source values if a result is unexpected.
WPS Spreadsheet

Combine Date Columns in WPS Spreadsheet

Use the DATE function in WPS Spreadsheet to create a date in a new column without replacing the original day, month, and year values.

  1. 1. Open the workbook: Open WPS Spreadsheet and use Open to select your workbook.
  2. 2. Enter the DATE formula: Select an empty result cell. If the day is in A1, the month is in B1, and the year is in C1, enter =DATE(C1,B1,A1) and press Enter.
  3. 3. Apply a date format: Select the result column and choose a date format from the number-format options on the Home tab.
  4. 4. Copy the formula down: Drag the result cell's fill handle down to create dates for the other rows.
Combine date components with the familiar DATE functionKeep source columns available for other worksheet referencesOpen and edit Microsoft Excel XLSX filesUse a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

Why does the formula show a number instead of a date?

Excel stores dates as serial numbers. Select the result cell or column, then choose Short Date or Long Date from the Number Format list on the Home tab.

Will the formula change my original columns?

No. Entering the DATE formula in a separate column leaves the day, month, and year cells unchanged, so other worksheets can still reference them.

What if my day, month, and year are in different columns?

Replace the cell references in =DATE(C1,B1,A1) with your own, keeping the arguments in year, month, day order.

Why is the resulting date different from the source values?

Check the references and the day and month values. DATE adjusts some out-of-range values; for example, a month of 13 moves the result into the following year.