Trm ksh atensinya pak muh_ferdy. Barusan saya coba ketik formula Datedif sesuai sintaks yg bpk sebutkan tapi gak bisa.. Trus saya cari 'Datedif' di help excel 2003 koq gak nemu ya... Powered by Telkomsel BlackBerry®
-----Original Message----- From: [email protected] Sender: [email protected] Date: Thu, 9 Aug 2012 11:31:43 To: <[email protected]> Reply-To: [email protected] Subject: Re: [belajar-excel] Date Function - Berapa Bulan Selisih Waktunya?? Kl tidak salah formulanya : =DATEDIF(A1,B1,"m") Maaf kl salah. Sent from my BlackBerry® powered by Sinyal Kuat INDOSAT -----Original Message----- From: [email protected] Sender: [email protected] Date: Thu, 9 Aug 2012 09:48:00 To: Belajar Excel<[email protected]> Reply-To: [email protected] Subject: [belajar-excel] Date Function - Berapa Bulan Selisih Waktunya?? Salam beexceler.. Saya ada pertanyaan terkait kelompok Date Function, yaitu brp bulan selisih antar waktu yg dicari?? Misal: Sel A1 isinya Oktober 2011 Sel B1 isinya Februari 2012 Di sel C1 akan dibuat formula yg bahasa verbalnya: "Berapa Bulan Selisih Waktu antara keduanya??" Hasil yg diinginkan adlh "4" --->> maksudnya: Februari 2012 jaraknya adlh 4 bulan dari Oktober 2011. Mohon dibantu bgmn susunan formulanya?? Trm ksh sblmnya Imam Sinurat - Sumut Powered by Telkomsel BlackBerry® ------------------------------------ --------------------------------------------------------------------- bergabung ke milis (subscribe), kirim mail kosong ke: [email protected] posting ke milis, kirimkan ke: [email protected] berkunjung ke web milis http://tech.groups.yahoo.com/group/belajar-excel/messages melihat file archive / mendownload lampiran http://www.mail-archive.com/[email protected]/ atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/ menghubungi moderators & owners: [email protected] keluar dari membership milis (UnSubscribe): kirim mail kosong ke [email protected] ---------------------------------------------------------------------Yahoo! Groups Links ------------------------------------ --------------------------------------------------------------------- bergabung ke milis (subscribe), kirim mail kosong ke: [email protected] posting ke milis, kirimkan ke: [email protected] berkunjung ke web milis http://tech.groups.yahoo.com/group/belajar-excel/messages melihat file archive / mendownload lampiran http://www.mail-archive.com/[email protected]/ atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/ menghubungi moderators & owners: [email protected] keluar dari membership milis (UnSubscribe): kirim mail kosong ke [email protected] ---------------------------------------------------------------------Yahoo! Groups Links ------------------------------------ --------------------------------------------------------------------- bergabung ke milis (subscribe), kirim mail kosong ke: [email protected] posting ke milis, kirimkan ke: [email protected] berkunjung ke web milis http://tech.groups.yahoo.com/group/belajar-excel/messages melihat file archive / mendownload lampiran http://www.mail-archive.com/[email protected]/ atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/ menghubungi moderators & owners: [email protected] keluar dari membership milis (UnSubscribe): kirim mail kosong ke [email protected] ---------------------------------------------------------------------Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/belajar-excel/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/belajar-excel/join (Yahoo! ID required) <*> To change settings via email: [email protected] [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/

