array formula =SUM(N(WEEKDAY((ROW(INDIRECT(B3&":"&C3))),2)<6))
atau jika anda pakai excel 2003 dengan add-in analysis toolpak sudah diaktifkan pakailah fungsi NetWorkDays =NETWORKDAYS(B3,C3) -------------------------------------------------------------------------------- ----- Original Message ----- From: Gunawan Wibisono To: belajar exel Sent: Tuesday, January 05, 2010 1:47 PM Subject: [belajar-excel] Lama Cuti Dear All mohon bantuannya, bagaimana menghitung berapa lama cuti kerja tanpa dihitung hari libur (sabtu dan minggu) thx goen
ctv_Lama Cuti.xls
Description: MS-Excel spreadsheet
