Begini Sdr. Ari
Kalau tgl tsb di A1 , di B1 kasih rumus =IF( WEEKNUM(A2) > 52 ; 1 ; WEEKNUM(A2) ) atau =MAX( 1 ; MOD( WEEKNUM(A2) ; 53 )) . . . . On Wednesday, January 1, 2014 6:16 PM, abu.syuaib <[email protected]> wrote: Dear all, Mohon bantuan gimana cara agar weeknum untuk 30-31 des 2013 hasilnya week 1 Ari
