rumus 'Senin Pertama Bulan Depan' kiriman pak KhozHot thea.. :
=EOMONTH(F7,0)+
IF(WEEKDAY(EOMONTH(F7,0))=2,
WEEKDAY(EOMONTH(F7,0))-0,
IF(WEEKDAY(EOMONTH(F7,0))>2,
2-WEEKDAY(EOMONTH(F7,0))+7,
2-WEEKDAY(EOMONTH(F7,0))))
kayaknya masih dapat 'pendek'-kan menajdi...
=EOMONTH(F7,0)-
WEEKDAY(EOMONTH(F7,0))+
7*(WEEKDAY(EOMONTH(F7,0)+1)<>2)+2
--------------------------------------------------------------------------------
----- Original Message -----
From: Khozhot
Sent: Tuesday, March 30, 2010 1:52 PM
Kebetulan ketemu nech xi...xi...xi....
Wassalam,
...Zh0t thea
--------------------------------------------------------------------------------
2010/3/26 Sukardi <[email protected]>
Salam, ...
Numpang tanya, Bagaimana rumus untuk mencari tanggal / Hari Senin Bulan
berikutnya dari sel sebelah.
Atas bantuannya terima kasih
ctv_SeninPertama_BulanBerikutnya(vv).zi_
Description: Binary data
