=DATEDIF(A2,TODAY(),"Y")
=DATEDIF(A2,TODAY(),"YM")
=DATEDIF(A2,TODAY(),"YD")

banyak penjelasan dan tutor di dunia maya, antara lain (y g cukup oke:
http://www.cpearson.com/excel/datedif.aspx

Wassalam,
*Semprull Ki!!*






> 2012/6/19 selamat Rifki <[email protected]>
> > bagaimana cara mencari umur agar up to date tiap buka file ini ya...
> > terima kasih sebelumnya
> >
>

Attachment: fungsi DATEDIF (Semprull Ki).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Kirim email ke