Formula for Combining Different Values into One Date Column.

Posted on October 24, 2009 
Filed Under Excel Tips & Tricks

It is time for the fourth and final Excel tutorial of this Excel week. The tutorials that we’ve covered this week are some pretty cool ones. The first was the tutorial with a formula for checking future dates followed by the Excel tutorial for using the TEXT and the TODAY functions and we discussed yesterday a tutorial for combining the TEXT and the NOW functions.

 

In today’s 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.

 

Excel-formula-tutorial-pic1

 

  • Select Cell D2:D8
  • And type in the following formula =DATE(A2;B2;C2).

 

Excel-formula-tutorial-pic2

 

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

 

Excel-formula-tutorial-pic3

 

And that’s it for another Excel Tutorial week. I really hope you’ve enjoyed this week and that you’ve learned something. Next week we’ll continue with our normal Tips and Tricks. Have a great weekend and I’ll talk to you all on Monday.

 

Do you want to see more? This is related...


Buzz Up Digg Mixx
Print


Comments

2 Responses to “Formula for Combining Different Values into One Date Column.”

  1. Billigflüge on December 30th, 2008 10:55 am

    thank u very mcuh
    I’m a java, C developper but i don’t úse excel often because I haven’t had enough time to learn it.Your tutorial was very helpful
    keep up the goiod work
    I will be a regular reader of ur blog

  2. Khrisna on April 10th, 2009 6:43 am

    I like this

Leave a Reply