Formula for Combining Different Values into One Date Column.

Posted on May 30, 2008 
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

  Here are a few posts the other readers recommend you check out.

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...

Invite your friends to the World of Office.
Did you ever thought about publishing your own eBook or PDF report?
Invite your friends to the World of Office.
Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 3 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!


If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.





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