getting date in special form
 

Hi all i have a sheet with dates of the following form
Year Month Day
1993 May 23
1991 January 28

and i want to gather them into one row instead of three so i want
something of this format

I Wana Get
23-05-93
28-01-91

How is it possible?
Help appreciated

getting date in special form
 

Hi

Try
=--(C2&"/"&B2&"/"&A2)
Format the cell, FormatCellsNumberCustom dd-mm-yy

--
Regards
Roger Govier

"Totti" wrote in message
...
Hi all i have a sheet with dates of the following form
Year Month Day
1993 May 23
1991 January 28

and i want to gather them into one row instead of three so i want
something of this format

I Wana Get
23-05-93
28-01-91

How is it possible?
Help appreciated

getting date in special form
 

If you are American then this would work

=--(B1&" "&C1&", "&A1)

and format as date the way you want


If you are Italian then this might work


=DATA(A1;CERCA.VERT(B1;{"gennaio"\1;"febbraio"\2;" marzo"\3;"aprile"\4;"maggio"\5;"giugno"\6;"luglio" \7;"agosto"\8;"settembre"\9;"ottobre"\10;"novembre "\11;"dicembre"\12};2;0);C1)

You will have to change the ; to whatever delimiter you use


If you put a table like this in let's say K1:L12

then you can use


=DATA(A1;CERCA.VERT(B1;K1:L12;2;0);C1)

Of course if you are not Italian you can still use that method


=DATE(A1,VLOOKUP(B1,{"January",1;"February",2;"Mar ch",3;"April",4;"May",5;"June",6;"July",7;"August" ,8;"September",9;"October",10;"November",11;"Decem ber",12},2,0),C1)


--


Regards,


Peo Sjoblom

"Totti" wrote in message
...
Hi all i have a sheet with dates of the following form
Year Month Day
1993 May 23
1991 January 28

and i want to gather them into one row instead of three so i want
something of this format

I Wana Get
23-05-93
28-01-91

How is it possible?
Help appreciated

getting date in special form
 

Hi,

And just to be cute:

=--(C1&""&B1&""&A1)

and shorter still

=--(C1&B1&A1)

Thanks,
Shane Devenshire


"Totti" wrote:

Hi all i have a sheet with dates of the following form
Year Month Day
1993 May 23
1991 January 28

and i want to gather them into one row instead of three so i want
something of this format

I Wana Get
23-05-93
28-01-91

How is it possible?
Help appreciated