ganti ; jadi, ex: =text(weekday(A1),"dddd") tapi hasilnya tergantung bahasa yang dipakai di regional setting. anda bisa set ke indo
--- NewNux <[EMAIL PROTECTED]> wrote: > maaf pak/ibu, > saya coba rumus yg bpk/ibu kasih tp ko tdk bisa > yach.....? > > On 7/16/07, Reny Komalasari <[EMAIL PROTECTED]> wrote: > > > > Salam > > > > A1 --> 16/07/07 > > A2 --> =text(weekday(A1);"dddd") --> akan > menghasilkan output --> Senin > > A2 --> =text(weekday(A1);"ddd") --> akan > menghasilkan output --> Sen > > > > semoga membantu.. > > > > Salam > > ~ Reny ~ > > > > > > > > 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". > > > > > > > > Marto Kosasih > > > > > > > > CV. GARASI > > > > > > > > Jl. Riau Gg. Geliga No.7A > > > > > > > > Pekanbaru - 28155 > > > > > > > > Riau, Indonesia > > > > > > > > Tel. +62 761 7076711 > > > > > > > > Fax. +62 761 44806 > > > > > > > > [Non-text portions of this message have been > removed] > > > > > > > > > > > > > > > > > >[Non-text portions of this message have been > removed] > > > > > > > > > > [Non-text portions of this message have been > removed] > > > > > > > > > > -- > Thanks & Best Regards > > > NewNux06 > > > [Non-text portions of this message have been > removed] > > ____________________________________________________________________________________ We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list. http://tv.yahoo.com/collections/265 -- 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/
