getting date in special form

  • Thread starter Thread starter Totti
  • Start date Start date
T

Totti

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
 
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;"March",3;"April",4;"May",5;"June",6;"July",7;"August",8;"September",9;"October",10;"November",11;"December",12},2,0),C1)


--


Regards,


Peo Sjoblom
 
Hi,

And just to be cute:

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

and shorter still

=--(C1&B1&A1)

Thanks,
Shane Devenshire
 
Back
Top