Membuat Kalender Otomastis di Excel

Pada tips kali ini kita akan membuat dengan fungsi Array

Mau tau klik aja di 
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

 

Sumber: http://tips-ms-excel.blogspot.com/

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s