Selain menggunakan array formula, bisa tidak ya Mr Kid, soalnya kalo array tiny belum paham cara membaca formulanya :) Salam Tiny Powered by Telkomsel BlackBerry®
-----Original Message----- From: "Mr. Kid" <[email protected]> Sender: [email protected] Date: Fri, 16 Nov 2012 15:39:50 To: <[email protected]> Reply-To: [email protected] Subject: Re: [belajar-excel] Fw: Tidak Memperhitungkan Libur Nasional Bagaimana kalau bagian Row(blabla) dikurangi 1 ? =SMALL(IF(COUNTIF(LibNas,B7+ROW($1:$100)-1)=0,B7+ROW($1:$100)-1),C7) Wassalam, Kid. 2012/11/16 <[email protected]> > ** > > > ** :( hasilnya masih sama dgn yg tadi Mr Kid, bahkan lompat harinya lebih > jauh, tidak tepat seperti hasil akhir tgl yg diinginkan > > Salam > Tiny > Powered by Telkomsel BlackBerry® > ------------------------------ > *From: * "Mr. Kid" <[email protected]> > *Sender: * [email protected] > *Date: *Fri, 16 Nov 2012 13:57:42 +0700 > *To: *<[email protected]> > *ReplyTo: * [email protected] > *Subject: *Re: [belajar-excel] Fw: Tidak Memperhitungkan Libur Nasional > > > > hehehe... > coba *array formula* : (asumsi : maksimal jumlah *hari tambahan* adalah > 50. > Ganti angka *100 *dengan angka lainnya (*2 kali lipat maksimal jumlah > hari tambahan*)) > =SMALL(IF(COUNTIF(*LibNas*,B7+ROW($1:$*100*))=0,B7+ROW($1:$*100*)),*C7*) > Pastikan hari *minggu *masuk dalam daftar *LibNas* > > Tapi formula di atas belum dicoba untuk banyak macam posisi hari dan *tambahan > hari* (nilai *C7*) > > Wassalam, > Kid. > > On Fri, Nov 16, 2012 at 1:35 PM, <[email protected]> wrote: > >> ** >> >> >> ** Tidak mewakili Mr Kid, karena jika saya menggunakan hari kerja 4 hari >> maka tgl terakhir adalah 28 Okt, sedangkan tgl 28 adalah hari minggu yaitu >> hari yg tidak diperhitungkan sebagai hari kerja, jadi jika 4 hari >> seharusnya jatuh pada tgl 29 karena tgl 26 dan 28 adalah tanggal merah. >> Salam >> Tiny >> Powered by Telkomsel BlackBerry® >> ------------------------------ >> *From: * "Mr. Kid" <[email protected]> >> *Sender: * [email protected] >> *Date: *Fri, 16 Nov 2012 13:30:07 +0700 >> *To: *<[email protected]> >> *ReplyTo: * [email protected] >> *Subject: *Re: [belajar-excel] Fw: Tidak Memperhitungkan Libur Nasional >> >> >> >> Coba pada D7 : >> =b7 + c7 >> >> Wassalam, >> Kid. >> >> On Fri, Nov 16, 2012 at 1:16 PM, <[email protected]> wrote: >> >>> ** >>> >>> >>> Dear All, >>> Saya ingin membuat tanggal jatuh tempo dgn tidak memperhitungkan libur >>> nasional dan hari minggu, saya ada mengadop VBA dr Alm mba siti, tetapi >>> hasil yg diinginkan kurang tepat, adakah yg bisa membantu.. >>> Terima kasih sebelumnya >>> Salam >>> Tiny >>> >>> Powered by Telkomsel BlackBerry® >>> >>> -----Original Message----- >>> From: Hartini FIN <[email protected]> >>> Date: Fri, 16 Nov 2012 05:46:30 >>> To: [email protected]<[email protected]> >>> Subject: Tidak Memperhitungkan Libur Nasional >>> >>> >>> CONFIDENTIAL NOTE: The information contained in this email is intended >>> only for the use of the individual or entity named above and may contain >>> information that is privileged, confidential and exempt from disclosure >>> under applicable law. If the reader of this message is not the intended >>> recipient, you are hereby notified that any dissemination, distribution or >>> copying of this communication is strictly prohibited. If you have received >>> this message in error, please immediately notify the sender and delete the >>> mail. Thank you. >>> >>> >> > >
