Combine Day, Month, and Year Columns into an Excel Date
Question details
Combine separate day, month, and year values into a real Excel date without changing the original columns.

- 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.
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.
Use the DATE Function in a New Excel Column
Create a real Excel date in a separate column while keeping the source values available.
Select cell D1 and enter =DATE(C1,B1,A1), then press Enter. DATE takes the year first, followed by the month and day.
Select column D, open the Number Format list on the Home tab, and choose Short Date or Long Date.
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.

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. Open the workbook: Open WPS Spreadsheet and use Open to select your workbook.
- 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. Apply a date format: Select the result column and choose a date format from the number-format options on the Home tab.
- 4. Copy the formula down: Drag the result cell's fill handle down to create dates for the other rows.

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.




