punyaku kok outputnya #value! please advise....
"Rex Lei" <[EMAIL PROTECTED]> Sent by: [email protected] 07/17/2007 09:54 AM Please respond to [email protected] To [email protected] cc Subject Re: [ITCENTER] Nama Hari dari Tanggal di Excel mungkin gini dulu .. coba format tanggal 16/07/07 di format dulu jadi date .. setau gw biasanya formatnya itu mm/dd/yy .. dan formulanya jalan kok =text(weekday(a1),"dddd") On 7/16/07, Heribertus Yulianton <[EMAIL PROTECTED]> wrote: > > Pada tanggal 16/07/07, Heribertus Yulianton <[EMAIL PROTECTED] <heribertus%40gmail.com>> > menulis: > > Pada tanggal 16/07/07, NewNux <[EMAIL PROTECTED] <newnux06%40gmail.com>> > menulis: > > > maaf pak/ibu, > > > saya coba rumus yg bpk/ibu kasih tp ko tdk bisa yach.....? > > > > > > > > > coba yang ini: > > =text(weekday(A1);"dddd") > > > > oops, maksudnya > =text(weekday(A1),"dddd") > > outputnya: Monday > > Salam, > Heri _._,___ [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/
