Terima kasih banyak pak bagus, sangat membantu sekali! From: Bagus <ba...@kingjim.co.id> To: belajar-excel@yahoogroups.com Sent: Tuesday, October 9, 2012 1:09 PM Subject: Re: [belajar-excel] Aplikasi Kalendar buat Reminder Pekerjaan
Dear Pak Azwar; Mungkin begini: =TEXT(TODAY(),"[$-421]dddd") Bagus ----- Original Message ----- >From: Azwar Rhosyied >To: belajar-excel@yahoogroups.com >Sent: Tuesday, October 09, 2012 11:57 AM >Subject: Re: [belajar-excel] Aplikasi Kalendar buat Reminder Pekerjaan > > >Terima kasih Pak Abe, sangat membantu sekali > >Maaf, ada tambahan, kalo mau tahu hari ini (misal) selasa dari tanggal >(09/10/12) tersebut, bagaimana? > >Terima kasih. > > >From: utthank abe <abeutth...@gmail.com> >To: belajar-excel@yahoogroups.com >Sent: Tuesday, October 9, 2012 11:18 AM >Subject: Re: [belajar-excel] Aplikasi Kalendar buat Reminder Pekerjaan > > > >mungkin ada member laen yang lebih cantik zoluzinya :)1. =TODAY() >2. >=IF(DAY(TODAY())<=7;"I";IF(DAY(TODAY())<=14;"II";IF(DAY(TODAY())<=21;"III";IF(DAY(TODAY())>21;"IV")))) > >
