Merge Day, Month, and Year in Excel

To merge separate day, month, and year values into a real Excel date, enter =DATE(C2,B2,A2) in a new cell when the year is in C2, month in B2, and day in A2. Format the result as a date, then fill the formula down for other rows. The DATE function uses year, month, day order and creates a date Excel can sort and use in calculations.

What You’ll Need

Before starting, make sure the day, month, and year values are in separate cells, with one complete set on each row. The example below assumes day is in column A, month is in column B, and year is in column C. Use four-digit years, such as 2025, to avoid unexpected century results. You will also need a blank column for the combined dates.

A worksheet containing day, month, and year values in separate columns.
A blank output column where Excel can place the combined dates.
Microsoft Excel for Microsoft 365 on Windows. The formula is the same in Excel for Mac and Excel for the web, though some keyboard shortcuts and formatting controls differ.

Step-by-Step

Check how the source data is arranged. Find a row where the day, month, and year are all present. For this guide, day is in A2, month is in B2, and year is in C2. For example, A2 could contain 15, B2 could contain 3, and C2 could contain 2025. That set represents March 15, 2025. If your columns are in a different order, note their cell references; the formula must still pass the year first, then month, then day.
Choose an empty cell for the result. Click D2, or the first blank cell on the same row as your source values. Keeping the result alongside its source values makes it easier to check the formula and fill it down. If D already contains data, use another empty column and leave the original day, month, and year columns unchanged until you have checked the results.
Enter the DATE formula. With the day in A2, month in B2, and year in C2, enter =DATE(C2,B2,A2) in D2 and press Enter. DATE requires its arguments in year, month, day order, which is why the cell references do not follow the left-to-right order of the source columns. In the example values, the formula returns the date March 15, 2025.
Check that Excel produced the intended date. Excel may initially display a number instead of a familiar date. That number is often the date’s serial value, not a failed formula. If the display looks like a date, compare its day, month, and year with the source cells. Remember that date display order depends on the number format and regional settings, so 03/04/2025 can mean different dates in different locales.
Format the result as a date if needed. Select D2, then use Home > Number Format and choose a date format. For a particular layout, press Ctrl+1 on Windows to open Format Cells, choose the Number tab, and select Date or Custom. A custom format such as dd mmmm yyyy displays a date like 15 March 2025; yyyy-mm-dd displays it as 2025-03-15. These formats change how the date looks, not the underlying date value. On a Mac, Command+1 opens Format Cells; Excel for the web has number-format options on the Home tab.
Copy the formula to the other rows. Select D2 and drag the small fill handle at the cell’s lower-right corner down through the rows that contain source values. You can also copy D2, select the destination cells below it, and paste. Excel adjusts the references for each row: the next formula uses C3, B3, and A3. Check at least the first and last filled rows to confirm the ranges line up.
Check dates with different days and months. Look at a row where the day is greater than 12, if one is available. A date such as 15 March is easier to verify than 04/05, which can be read as April 5 or May 4 depending on regional settings. Also check a leap-year date or a month-end date if those occur in your data. This quick review can catch swapped columns and bad source values.
Optionally replace formulas with fixed date values. Keep the formulas if you may correct or update the source columns; the combined dates will recalculate automatically. If you need standalone results, copy the completed date column, then use Home > Paste > Paste Values. Verify the pasted dates before removing or changing the source columns. Pasting values keeps the date results but removes the formulas that generated them.

Common Mistakes

Putting the arguments in day-month-year order. DATE is unusual if you are thinking of a written date: its required order is year, month, day. With the example layout, =DATE(C2,B2,A2) is correct. Reversing the references can produce a different date or an unexpected result.

Using a two-digit year. Supply a four-digit year, such as 2025, rather than 25. In DATE, a year argument from 0 through 1899 is treated as an offset from 1900, so a value of 25 produces a date in 1925, not 2025. A two-digit year can therefore create a valid-looking but incorrect date.

Assuming DATE rejects every impossible date. DATE normalizes values outside their usual ranges. For example, a month value of 13 rolls into the next year, and an invalid day can roll into the following month. That behavior is useful for date arithmetic, but it means an input such as February 30 may not trigger an error. Check imported or manually entered components against the calendar rather than assuming the formula validates them.

Joining the values as text instead of making a date. Concatenating the three cells can create a string that looks like a date but is not necessarily a usable Excel date. DATE creates a date value that can be sorted chronologically, formatted, and used in date calculations. Use text concatenation only when you specifically need a label for display or export.

Confusing the display with the stored value. A result shown as a number may simply need date formatting. Conversely, a result that looks like a date may be text. Formatting a cell as Date does not turn text into a genuine date; the DATE formula is what combines numeric components into a date value.

Tips

Use a clear heading such as Combined date for the output column, and preserve the original component columns until you have checked the results. If the worksheet has many rows, turn the range into an Excel table with Insert > Table. A formula entered in a table column can fill down automatically as part of the calculated column, and table headings help prevent confusion about which source is day, month, or year.

Choose a format that makes the date unambiguous. A month written out, such as 15 March 2025, is easy to read; the ISO-style format 2025-03-15 is also clear and sorts naturally when represented consistently. Avoid relying on a short format such as 03/04/25 when people using different regional settings will view the workbook.

If the source data is imported, check whether the components are numbers. A number aligned left may be stored as text, although alignment can be changed manually and is not a definitive test. Use the formula result and a few known rows to verify the data. Keep the year as four digits, and avoid changing the workbook’s regional settings just to make one date column look right; choose an explicit number format instead.

Troubleshooting

The cell shows a number. The formula may be working. Select the result cell and choose a date format from Home > Number Format, or open Format Cells with Ctrl+1 on Windows. If the formula bar shows the DATE formula and the displayed number changes to a calendar date after formatting, the result is a valid Excel date.

The date is wrong by a month or by several days. Check that the year, month, and day references are in the correct DATE argument positions. Confirm that the source columns contain what their headings say; an imported file may label a column incorrectly or arrange components differently. Check a row with a day above 12 to distinguish day and month values clearly.

The result is in the wrong century. Inspect the year cell for a two-digit value. Replace 25 with 2025, for example, then confirm the result. Do not rely on the way a short date is displayed to determine its century; use a format that shows the full year while checking.

You see a formula error such as #VALUE!. One or more referenced cells may contain text that Excel cannot use as a number, a blank where a component is required, or other unexpected content. Check A2, B2, and C2 individually, remove extra spaces or stray characters, and enter numeric day and month values with a four-digit numeric year. If the cells contain month names rather than month numbers, convert those names to numbers first; DATE’s month argument is intended to be a month number.

Some rows work but others do not. Check the source components in the failing rows, especially blanks, misspellings, and values outside the expected ranges. Also confirm the formula was filled down far enough and that each row refers to its own cells. Because DATE can roll invalid month or day numbers into another date, compare questionable outputs with the original data rather than treating every non-error result as correct.

Frequently Asked Questions

Does DATE create a real Excel date or just combine text?
DATE creates an Excel date value, stored as a serial number and displayed using a date format. This is generally preferable to joining the components as text because Excel can sort the dates and use them in date calculations.

What if my columns are year, month, and day?
Use the cells in the order DATE expects: year first, month second, day third. For example, if year is in A2, month is in B2, and day is in C2, enter =DATE(A2,B2,C2). Change the references to match your actual layout.

Can I merge the values when the month is written as a word?
DATE is most reliable when its month argument is a number from 1 to 12. Convert month names such as March to their corresponding number before using DATE. Text-to-date conversion can depend on language and regional settings, so check converted values against known dates.

Why does Excel show a different date order from my formula?
The formula determines the date value, while the cell’s number format and regional settings determine how that value is displayed. Apply an explicit format, such as dd mmmm yyyy or yyyy-mm-dd, to make the intended order clear.

Will the combined date update if I change the day, month, or year?
Yes. A cell containing a DATE formula recalculates when one of its referenced component cells changes. If you paste the results as values, however, they no longer update from the original day, month, and year cells.

Can DATE handle leap days?
Yes, when the components describe a valid leap day. For example, February 29 is valid in 2024, but not in 2025. Check the source components carefully because DATE can normalize invalid days into the following month instead of rejecting them.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.