Kagem Pedhet, sorry repost nieh yang tadi gak nyampe kali..
coba begini: =CHOOSE(WEEKDAY(A1,2),"Senin","Selasa","Rabu","Kamis","Jum'at","Sabtu","Minggu") Note: A1: Cell berisi tanggal dalam fungsi weekday isikan 1 jika hari pertama dalam seminggu adalah hari Minggu atau 2 jika hari pertama dalam seminggu adalah hari Senin nuwun, I prefer drawing to talking. Drawing is faster, and leaves less room for lies. (Le Corbusier) sederek Pedhet, panjenengan nyerat mekaten: > > andri hindarta wrote: > > Contoh : > > A1 : berisi tanggal > > A2 : =WEEKDAY(A1) > > A3 : =IF(B1=1,"Mingu",IF(B1=2,"Senin",IF(B1=3,"Selasa",IF(B1=4,"Rabu", > > IF(B1=5,"Kamis",IF(B1=6,"Jumat","Sabtu")))))) > > > > Begitu ...? > > B1 itu mungkin maksudnya A2 yah ..? msh nggak bsia nih. btw saya pakai > Excel 2003 > > <deleted>
