Need a Date

[JoshuaX1980]

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

 

[Norie]

Have you looked at the DATE worksheet function?

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

 

[HalfAce]

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