Minggu, 30 Januari 2011

Rumus Mencari Umur di Ms. Excel


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")