Need a Date

JoshuaX1980

Board Regular
Joined
Jan 26, 2005
Messages
80
Hi,
I want one column containing the date (dd-mm-yyyy) , but now I received a file containing 1960 in the first, 1 (january) in the second and 1 (day) in the third column. And this data goes on to row 6000 (data from 1960 up to app. 2003). How can I group the date represented in 3 columns in 1 column?

What I have:
|1960| 1|1
|1960| 1|2
|1960| 1|3

and I want:
|1-1-1960|
|2-1-1960|

Does anybody know?

Kind Regards,
Lennart
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,318
Office Version
  1. 365
Platform
  1. Windows
Have you looked at the DATE worksheet function?

It takes the year, day and month as arguments and returns the date.
 

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,456
Another option...
In D1 enter:
=C1&"-"&B1&"-"&A1
and copy down.

This will return as text. If that's not acceptable it can be coerced into a numeric value by using:
=--(C1&"-"&B1&"-"&A1)
instead. Then format to suit.

Norie's suggestion is the way to go. This is just another option. :wink:

Hope it helps,
Dan
 

Forum statistics

Threads
1,148,397
Messages
5,746,460
Members
424,020
Latest member
LongDoo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top