Anda hanya butuh mengubah format cell dari excel tersebut dengan menggunakan 'Custom' dan set Type-nya: "dddd" <red: tanpa tanda kutip dua>.
Semoga membantu. Keep Posting. Quoting Marto Kosasih <[EMAIL PROTECTED]>: > Dear All, > > Apakah ada function / formula di excel untuk membuat nama hari berdasarkan > tanggal yang tertera pada suatu cell ? > > Misalkan di A1 = 14/07/07, maka nanti A2 keluar tulisan "Sabtu" / > "Saturday". Barst Mendas S Developer / IT Solution PT. Solusindo Total Teknikatama Wisma BNI Kota 46 Jln. Sudirman Kav.1 - 24th Floor Phone : (62-21)251 4718 Fax : (62-21)251 4719 -- 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/