Coba formula berikut: =Text(Date(Year($B$1);Month($B$1);Day(A4));"dddd")
Best Regards, -Miss Jan Raisin- 2013/2/5 MIKE <[email protected]> > ** > > > ** > master excel.... > > Mohon bantuannya saya mau di kolom keterangan bisa muncul otomatis nama2 > hari (Minggu sd sabtu) jika kita memasukan data tanggal (angka 1.2.3.4 dst) > disini contoh bulan februari 2013 sebagai helpernya > terima kasih > MIKE > > BULAN : Feb-13 TANGGAL KETERANGAN 1 JUMAT 2 SABTU 3 MINGGU 4 SENIN 5 > SELASA 6 RABU 7 KAMIS 8 JUMAT 9 SABTU 10 MINGGU 11 SENIN 12 SELASA 13 RABU > 14 KAMIS 15 JUMAT 16 SABTU 17 MINGGU > > > > > > > > > > > > > > > PT. BANK ARTHA GRAHA INTERNASIONAL TBK. DISCLAIMER: > > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. This message contains confidential information > and is intended only for the individual named. If you are not the > named addressee you should not disseminate, distribute or copy this > e-mail. Please notify the sender immediately by e-mail if you have > received this e-mail by mistake and delete this e-mail from your > system. If you are not the intended recipient you are notified that > disclosing, copying, distributing or taking any action in reliance on > the contents of this information is strictly prohibited. > > >
