Mas Agunk;

Coba begini:
=IF(LEN(D7),D7,IF(WEEKDAY(B7)=1,"Tidak ada keterangan",D7))

Copas kebawah


Wassalam

~ Bagus ~



  ----- Original Message ----- 
  From: [email protected] [belajar-excel] 
  To: [email protected] 
  Sent: Friday, August 15, 2014 10:50 AM
  Subject: [belajar-excel] Kalendar Absensi [1 Attachment]


    

  Dear All Be-Exceller

  Mohon Bantuan Penjelasan Pada File Terlampir. . .

  Mengubah Keterangan Pada hari minggu, , ,




  Thanks,B'Regards

     -Agunk-


  

Kirim email ke