Ubah format cell-nya :
Klik kanan -> format cell -> pilih custom :
- ketik : DDD untuk nama hari pendek (Sun,Mon, ..)
- ketik : DDDD untuk nama hari panjang (Sunday,Monday , ..)
----- Original Message -----
From: "Dodi Andika" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 17, 2004 1:42 PM
Subject: Re: [ITCENTER] Nampilin Hari di Excel
>
> coba ini deh
>
> =TEXT(WEEKDAY("05/09/2004"),"dddd")
>
> At 01:31 PM 9/17/2004, you wrote:
>
>
> >Saya punya data sebagai berikut:
> >
> > Tanggal Hari
> >
> > 05/09/200 ............
> >
> >Gimana caranya bikin fomula di excel untuk menampilkan Nama hari pada
> >tanggal 05/09/2004.
> >Tampilan seharusnya Minggu (Sunday)...
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail is new and improved - Check it out!
> http://promotions.yahoo.com/new_mail
>
>
> --
> www.ITCENTER.or.id - Komunitas Teknologi Informasi Indonesia
> Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
> ::: Hapus bagian yang tidak perlu (footer, dst) saat reply! :::
> ## Forum: ITCENTER.or.id/forum ## Jobs: ITCENTER.or.id/jobs ##
> Yahoo! Groups Links
>
>
>
>
>
>
>
--
www.ITCENTER.or.id - Komunitas Teknologi Informasi Indonesia
Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
::: Hapus bagian yang tidak perlu (footer, dst) saat reply! :::
## Forum: ITCENTER.or.id/forum ## Jobs: ITCENTER.or.id/jobs ##
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> 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/
