Hello Mury Anto,
Pada formula di kolom D :
=CONCATENATE(DATEDIF(B2,$C$2,"Y")," Tahun, ",DATEDIF(B2,$C$2,"YM")," Bulan,
",DATEDIF(B2,$C$2,"MD")," Hari")
ubah semua rujukan ke cell B2 dengan formula di cell B2 (karakter = tidak
usah ikut serta)
=DATEVALUE(MID(A2,FIND(",",A2)+1,LEN(A2) ))
Jadinya :
=CONCATENATE(DATEDIF(DATEVALUE(MID(A2,FIND(",",A2)+1,LEN(A2) )),$C$2,"Y"),"
Tahun, ",DATEDIF(DATEVALUE(MID(A2,FIND(",",A2)+1,LEN(A2) )),$C$2,"YM"),"
Bulan, ",DATEDIF(DATEVALUE(MID(A2,FIND(",",A2)+1,LEN(A2) )),$C$2,"MD"),"
Hari")
Kid.
2009/6/19 mury anto <mury_an...@yahoo.co.id>
>
>
> Mohon bantuannya ya,
> Pertanyaan terlampir, soalnya gagal terus saya menggabungkan rumusnya
> sebelumnya terima kasih
>
> ------------------------------
> .
>
>
>
