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. >> >> > >
