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

<*> 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/

Kirim email ke