It's working, thanks ya pak ghozi
;)
Powered by Telkomsel BlackBerry®
-----Original Message-----
From: ghozi alkatiri <ghozialkat...@yahoo.co.id>
Sender: belajar-excel@yahoogroups.com
Date: Wed, 21 Nov 2012 15:43:49
To: belajar-excel@yahoogroups.com<belajar-excel@yahoogroups.com>
Reply-To: belajar-excel@yahoogroups.com
Subject: Bls: [belajar-excel] Fw: Tidak Memperhitungkan Libur Nasional
array formula
{=(C7-B7+1)-SUM(COUNTIF(LibNas!$B$3:$B$8;ROW($1:$31)-1+B7))}
wassalam
Ghozi Alkatiri
________________________________
Dari: "hartini...@yahoo.co.id" <hartini...@yahoo.co.id>
Kepada: belajar-excel@yahoogroups.com
Dikirim: Rabu, 21 November 2012 12:25
Judul: [belajar-excel] Fw: Tidak Memperhitungkan Libur Nasional
Dear all,
Kemarin saya pernah menanyakan bagaimana menentukan tanggal akhir dgn tidak
memperhitungkan libur nasional, dan telah dibantu oleh Mr. Kid dgn formula yg
harus dipahami baik2 bru saya mengerti (dasar tiny yang lambat paham hehehe)
Skrng saya ingin mengetahui case yg sebaliknya, bagaimana menentukan jumlah
hari dr tgl awal ke tanggal akhir dgn tdk memperhitungkan libur nasional,
attach terlampir dgn penjelasan hasil yg diinginkan.
Mohon bantuan ya bagi rekan2 semua
Terima kasih sebelumnya
Salam
Tiny
Powered by Telkomsel BlackBerry®
-----Original Message-----
From: Hartini FIN <hartini....@bukitmakmur.com>
Date: Wed, 21 Nov 2012 01:47:33
To: hartini...@yahoo.co.id<hartini...@yahoo.co.id>
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.
