Menghitung Umur dengan Fungsi DATEDIF

Bagaimanakah menampilkan umur seseorang dengan rumus excel, saya akan memeberikan contoh dengan beberapa kasus.

KASUS A:

Nah kasus A ini ingin menghitung umur dari 2 Tanggal (Hari ini dan Ulang Tahun), tetapi berupa angka2x, mohon diperhatikan di gambar, jadi bukan berupa format tanggal.
Rumus 1:
=IF(OR(A4="";B4="";C4="");"";IF(DATEDIF(DATE(C4;B4;A4);DATE(C7;B7;A7);"y")=0;"";DATEDIF(DATE(C4;B4;A4);DATE(C7;B7;A7);"y")&" tahun ")&IF(DATEDIF(DATE(C4;B4;A4);DATE(C7;B7;A7);"ym")=0;"";DATEDIF(DATE(C4;B4;A4);DATE(C7;B7;A7);"ym")&" bulan ")&IF(DATEDIF(DATE(C4;B4;A4);DATE(C7;B7;A7);"md")=0;"";DATEDIF(DATE(C4;B4;A4);DATE(C7;B7;A7);"md")&" hari"))
Rumus 2:
=IF(OR(A4="";B4="";C4="");"";IF(INT((DATE(C7;B7;A7)-DATE(C4;B4;A4))/365,25)=0;"";INT((DATE(C7;B7;A7)-DATE(C4;B4;A4))/365,25)&" tahun ")&IF(INT(MOD((DATE(C7;B7;A7)-DATE(C4;B4;A4))/365,25;1)*12)=0;"";INT(MOD((DATE(C7;B7;A7)-DATE(C4;B4;A4))/365,25;1)*12)&" bulan ")&IF(INT(MOD((DATE(C7;B7;A7)-DATE(C4;B4;A4))/30,4375;1)*30,4375)=0;"";INT(MOD((DATE(C7;B7;A7)-DATE(C4;B4;A4))/30,4375;1)*30,4375)&" hari"))

KASUS B:

Kasus B ini berbeda sedikit, karena saya akan membandingkannya langsung dengan fungsi TODAY(), jadi yang di-input hanya tanggal ulang tahunnya saja.
Rumus 1:
=IF(OR(A17="";B17="";C17="");"";IF(DATEDIF(DATE(C17;B17;A17);DATE(YEAR(TODAY());MONTH(TODAY());DAY(TODAY()));"y")=0;"";DATEDIF(DATE(C17;B17;A17);DATE(YEAR(TODAY());MONTH(TODAY());DAY(TODAY()));"y")&" tahun ")&IF(DATEDIF(DATE(C17;B17;A17);DATE(YEAR(TODAY());MONTH(TODAY());DAY(TODAY()));"ym")=0;"";DATEDIF(DATE(C17;B17;A17);DATE(YEAR(TODAY());MONTH(TODAY());DAY(TODAY()));"ym")&" bulan ")&IF(DATEDIF(DATE(C17;B17;A17);DATE(YEAR(TODAY());MONTH(TODAY());DAY(TODAY()));"md")=0;"";DATEDIF(DATE(C17;B17;A17);DATE(YEAR(TODAY());MONTH(TODAY());DAY(TODAY()));"md")&" hari"))
Rumus 2:
=IF(OR(A17="";B17="";C17="");"";IF(INT((DATE(YEAR(TODAY());MONTH(TODAY());DAY(TODAY()))-DATE(C17;B17;A17))/365,25)=0;"";INT((DATE(YEAR(TODAY());MONTH(TODAY());DAY(TODAY()))-DATE(C17;B17;A17))/365,25)&" tahun ")&IF(INT(MOD((DATE(YEAR(TODAY());MONTH(TODAY());DAY(TODAY()))-DATE(C17;B17;A17))/365,25;1)*12)=0;"";INT(MOD((DATE(YEAR(TODAY());MONTH(TODAY());DAY(TODAY()))-DATE(C17;B17;A17))/365,25;1)*12)&" bulan ")&IF(INT(MOD((DATE(YEAR(TODAY());MONTH(TODAY());DAY(TODAY()))-DATE(C17;B17;A17))/30,4375;1)*30,4375)=0;"";INT(MOD((DATE(YEAR(TODAY());MONTH(TODAY());DAY(TODAY()))-DATE(C17;B17;A17))/30,4375;1)*30,4375)&" hari"))

KASUS C:

Nah yang ini ber-format tanggal, rumusnya jadi lebih mudah:
Rumus 1:
=IF(OR(A26="";B26="");"";IF(DATEDIF(B26;A26;"y")=0;"";DATEDIF(B26;A26;"y")&" tahun ")&IF(DATEDIF(B26;A26;"ym")=0;"";DATEDIF(B26;A26;"ym")&" bulan ")&IF(DATEDIF(B26;A26;"md")=0;"";DATEDIF(B26;A26;"md")&" hari"))
Rumus 2:
=IF(OR(A26="";B26="");"";IF(INT((A26-B26)/365,25)=0;"";INT((A26-B26)/365,25)&" tahun ")&IF(INT(MOD((A26-B26)/365,25;1)*12)=0;"";INT(MOD((A26-B26)/365,25;1)*12)&" bulan ")&IF(INT(MOD((A26-B26)/30,4375;1)*30,4375)=0;"";INT(MOD((A26-B26)/30,4375;1)*30,4375)&" hari"))

KASUS D:

Sama dengan yang diatas, tetapi yang sekarang dibandingkan langsung dengan fungsi TODAY()
Rumus 1:
=IF(A35="";"";IF(DATEDIF(A35;TODAY();"y")=0;"";DATEDIF(A35;TODAY();"y")&" tahun ")&IF(DATEDIF(A35;TODAY();"ym")=0;"";DATEDIF(A35;TODAY();"ym")&" bulan ")&IF(DATEDIF(A35;TODAY();"md")=0;"";DATEDIF(A35;TODAY();"md")&" hari"))
Rumus 2:
=IF(A35="";"";IF(INT((TODAY()-A35)/365,25)=0;"";INT((TODAY()-A35)/365,25)&" tahun ")&IF(INT(MOD((TODAY()-A35)/365,25;1)*12)=0;"";INT(MOD((TODAY()-A35)/365,25;1)*12)&" bulan ")&IF(INT(MOD((TODAY()-A35)/30,4375;1)*30,4375)=0;"";INT(MOD((TODAY()-A35)/30,4375;1)*30,4375)&" hari"))

FILE LATIHAN
Salam