Formula for Combining Different Values into One Date Column

In this Excel tutorial I want to show you how you can combine 3 columns that hold different date values into one column.

It’s a pretty simple formula but its Friday so I don’t believe it’s a real problem. Entering all the data in the spreadsheet takes up most time.

First you’ll need to create a spreadsheet that looks similar to this one.


Select Cell D2:D8

And type in the following formula =DATE(A2;B2;C2).


Then Click CTRL+ENTER and you’re done, you’re spreadsheet should look like this.