Mas Agung; coba begini pada E11: =IF(H11="cuti tahunan",NETWORKDAYS(B11,C11)+IF(OR(WEEKDAY(C11)<WEEKDAY(B11),WEEKDAY(C11)=7),1,0),0) Copas kebawah
Hapus kolom Helper (helper sudah masuk formula) Wassalam ~ Bagus ~ ----- Original Message ----- From: [email protected] [belajar-excel] To: [email protected] Sent: Thursday, August 21, 2014 2:31 PM Subject: Re: [belajar-excel] Rumus Hitung Cuti Tahunan Pak Bagus, , , Sory pak Kayak e Masih Ada yg Salah. . Misal Cuti 01 agst 2014 - 02 agst 2014 knp hasilnya 1 ya pak, harusnya kan 2 hari, Jum'at dan Sabtu Salam, -Agunk-
