Sunday, May 25, 2008

Membuat Kalender Otomatis

Excel 97|2000|2002|2003|2007



Pada tips kali ini kita akan membuat dengan fungsi Array

1. Tulis fungsi yang ada lihat digambar dengan hati-hati. Atau anda copy list formula di atas. Berikut ini:

=IF(MONTH(DATE(YEAR(B2);MONTH(B2);1))<>MONTH(DATE(YEAR(B2);MONTH(B2);1)-(WEEKDAY(DATE(YEAR(B2);MONTH(B2);1))-1)+{0;1;2;3;4;5}*7+{1\2\3\4\5\6\7}-1);"";DATE(YEAR(B2);MONTH(B2);1)-(WEEKDAY(DATE(YEAR(B2);MONTH(B2);1))-1)+{0;1;2;3;4;5}*7+{1\2\3\4\5\6\7}-1)

2. Blok seluruh cell hasil dari B4:H9
3. Tekan F2, tekan CTRL+SHIFT+ENTER

6 comments:

xclmedia said...

wow, thanks tips-tips excelnya.

Anil Kumar Pal said...

Intersting and beautiful blog lovely presentation thanks for sharing your views...Microsoft Outlook Support We24support tech team are available 24/7 for repairs on computers, printers, laptops, desktops. Our tech team taken to new heights with our technician’s knowledge and support.at 1-866-978-0799 ms word support

anil kumar said...

Intersting and beautiful blog lovely presentation thanks for sharing your views...Excel Support We24support tech team are available 24/7 for repairs on computers, printers, microsoft excel 2010laptops, desktops. Our tech team taken to new heights with our technician’s knowledge and support.at 1-866-978-0799 microsoft excel support

Krido Suseno said...

thanks gan...lumayan dapat tambahan ilmu nih...
http://lirikdangitar.blogspot.com

Anonymous said...

Hasilnya #VALUE, kok gak bisa ya?

Saprani said...

Thanks