Coba gunakan:
=DATE(YEAR(TODAY()),MID(A1,FIND("/",A1,1)+1,FIND("-",A1,1)-FIND("/",A1,1)-1),LEFT(A1,FIND("/",A1,1)-1))
dan
=DATE(YEAR(TODAY()),MID(A1,FIND("/",A1,5)+1,FIND("-",A1,1)-FIND("/",A1,1)-1),MID(A1,FIND("-",A1,1)+1,FIND("/",A1,5)-FIND("-",A1,1)-1))

atau
=DATE(2014,MID(A1,FIND("/",A1,1)+1,FIND("-",A1,1)-FIND("/",A1,1)-1),LEFT(A1,FIND("/",A1,1)-1))

2014-12-31 19:14 GMT+07:00 Tjahya Hartono [email protected]
[belajar-excel] <[email protected]>:

>
>
> Dear master excel,
>
> Bagaimana cara memecahkannya ya? data disamping kiri mau dirubah menjadi
> data tanggal
>
> Terima kasih bantuannya
>
>
>
> Tjahya H
>
>
>  
>

Attachment: Memisahkan tanggal.xlsx
Description: MS-Excel 2007 spreadsheet

Kirim email ke