coba juga formula sbb: =SUMPRODUCT(1*(WEEKDAY(ROW(INDIRECT(A1 & ":" & B1)),2)=7))
From: [email protected] [mailto:[email protected]] On Behalf Of Jan Raisin Sent: Wednesday, April 24, 2013 10:37 AM To: [email protected] Subject: Re: [belajar-excel] Mencari hari minggu ooo.. begitu tho.. coba formula berikut ini: =INT( ( ( B1 - ( ( WEEKDAY( B1 ) <> 7 )*WEEKDAY(B1) ) ) - A1 ) / 7 ) + 1
