Saya tambahan sedikit : Misalnya gini : Masuk Kerja : 12-Desember-03 (misal di cel A1) Keluar : 26-Agustus-05 (misal di cel B1) Berapa tahun, berapa bulan, berapa hari dia kerja? Rumusnya ini : Tahun : =DATEDIF(A1;B1;"y") Bulan : =DATEDIF(A1;B1;"ym") Hari : =DATEDIF(A1;B1;"md") Jadi dia udah kerja 1 tahun, 8 bulan, 14 hari. Salam, Agus S.
-----Original Message----- From: ITCENTER@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Conan Sent: 28 September 2006 4:15 To: ITCENTER@yahoogroups.com Subject: [ITCENTER] Re: Formula excell untuk menghitung jumlah bulan Coba saya bantu . =(YEAR(B1)-YEAR(A1))*12+MONTH(B1)-MONTH(A1) Semoga berhasil . Ya kudu . Eddy.L - ITM . <http://geo.yahoo.com/serv?s=97359714/grpId=1368087/grpspId=1600043695/msgId =150396/stime=1159444723> [Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## ## Jaket ITCENTER tersedia di http://shop.itcenter.or.id :: sponsor --------------------------------------------------- www.laptopseken.com - Buat apa beli PC kalau bisa beli laptop! Dapatkan harga spesial dari kami! -------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/