Coba begini aja pak, =(TEXT(WEEKDAY(A1),"dddd")) --> itu kalo di Office2007 =TEXT(WEEKDAY(A1);"dddd") --> ini kalo di OpenOffice
Sebaiknya nulis functionnya jangan diketik biasa, lebih baik pake fitur Office yang Insert Function itu loh. Semoga Membantu. ekoprayoga On 7/17/07, Phil Bailey <[EMAIL PROTECTED]> wrote: > > coba kamu pakai rumus ini > > > =IF(WEEKDAY(A1,2)=1,"Senin",IF(WEEKDAY(A1,2)=2,"Selasa",IF(WEEKDAY(A1,2)=3,"Rabu",IF(WEEKDAY(A1,2)=4,"Kamis",IF(WEEKDAY(A1,2)=5,"Jumat",IF(WEEKDAY(A1,2)=6,"Sabtu",IF(WEEKDAY(A1,2)=7,"Minggu",""))))))) > > --------------------------------- > Get the Yahoo! toolbar and be alerted to new email wherever you're > surfing. > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## ## Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
