[belajar-excel] Re: Mohon bantuan jumlah data

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Re: Mohon bantuan jumlah data

Bagus-2
Dear pak Fajar;

Coba ganti rumus yang ada di colom "Usia"
=(TODAY()-C6)/365
menjadi
=ROUND((TODAY()-C6)/365,0)
lalu copy kebawah

Semoga sesuai harapan.


Wassalam
   Bagus