Coba rumus yg ini
Ex :
Col A1 = 17/09/2004 Col B1 = DAY(A1)
Trus pd Col B1 ( format cell, Category pilih Custom type dddd )
----- Original Message -----
From: "Muhamad Safik" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 17, 2004 2:08 PM
Subject: [ITCENTER] Masalah di Excel
>
> Saya punya data sbb:
>
> Tanggal Hari
>
> 05/09/2004 ..........
>
> Gimana formulanya untuk menampilkan dari format tanggal (05 september
2004)
> menjadi format hari (Minggu/Sunday).
>
>
>
>
> --
> 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/
