Dear Pak Andi, Coba pakai formula ini pak,
Di kolom B1 : =CHOOSE(WEEKDAY(B1),"Minggu","Senin","selasa","Rabu","Kamis","Jumat","Sabtu") Dan kolom B4 : =B2&"/"&TEXT(B1,"dd-mmmm-yyyy") Contoh terlampir, Salam, Kus From: [email protected] [mailto:[email protected]] Sent: 05 Mei 2014 22:06 To: [email protected] Subject: ]] XL-mania [[ Seputar date, time dan penggabungan [1 Attachment] Selamat malam para master excel mania, mohon bantuan pencerahannya untuk beberapa pertanyaan dalam file excel terlampir. Terima Kasih atas bantuannya para master. Salam.
Copy of pertanyaan excel.xlsx
Description: Copy of pertanyaan excel.xlsx
