Rumus1
=DATEDIF(D5,TODAY(),"y")&" Tahun, "&DATEDIF(D5,TODAY(),"ym") | ||||||||
&" Bulan, "&DATEDIF(D5,TODAY(),"Md")&" Hari " | ||||||||
Rumus2 | ||||||||
=TEXT(IF(OR(MONTH(TODAY())>MONTH(D5),AND(MONTH(TODAY()) | ||||||||
=MONTH(D5),DAY(TODAY())>=DAY(D5))),(TODAY()-D5)/365.25,(TODAY()-D5)/365.25-1),"0") | ||||||||