Mohon maaf masih belum paham bapak toby, berarti kalo dibuat seperti itu nanti merepotkan dalam rumus ya. Padahal saya penasaran caranya. Tapi terima kasih untuk info dan bantuannya
Salam Tjahya Pada Jumat, 12 Juni 2015 21:20, "Toby kenzo tobyke...@yahoo.co.id [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: | Dera pak Tjahya,1.Jika mau merubah format,bisa gunakan format cell,jika mau di ubah dari 23 Maret ke 23/03,tinggal di rubah format cellnya aja dari dd mmm ke dd/mm. 2.Jika data sudah berbentuk data table,alangkah baiknya resultnya jg berbentuk data table jgn menggunakan result description akan sulit nanti kedepannya untuk membuat formulanya. TerimaKasih.Sent from Yahoo Mail on Android | From: Tjahya Hartono tjahyahart...@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com>; To: <belajar-excel@yahoogroups.com>; Subject: [belajar-excel] Menjumlah Kategori berupa format tanggal dan text [1 Attachment] Sent: Fri, Jun 12, 2015 4:22:58 AM | ID Nama Tanggal (Format Date) Tanggal (Format text) Hari Schedule Base on Check lock Time Kategori JM JP CI CO 1023 Ari 25-Feb 2/25/2015 Rabu 10:00 18:00 10:30 22:45 Terlambat Masuk 1023 Ari 26-Feb 2/26/2015 Kamis 10:00 18:00 10:00 18:20 1023 Ari 27-Feb 2/27/2015 Jumat 10:00 18:00 7:51 18:12 1023 Ari 28-Feb 2/28/2015 Sabtu 8:00 13:00 10:45 13:05 Terlambat Masuk 1023 Ari 2-Mar 3/2/2015 Senin 10:00 18:00 Ijin Sakit 1023 Ari 3-Mar 3/3/2015 Selasa 10:00 18:00 8:08 17:10 Pulang Lebih Cepat 1023 Ari 4-Mar 3/4/2015 Rabu 10:00 18:00 Ijin Sakit 1023 Ari 5-Mar 3/5/2015 Kamis 10:00 18:00 9:55 18:21 1023 Ari 6-Mar 3/6/2015 Jumat 10:00 18:00 7:45 18:15 Pertanyaan?Bagaimana caranya supaya tanggal yang masuk dalam kategori, bisa tertulis dengan format tanggal dan bulan saja? Misal:Kategori Terlambat Masuk 25/2, 28/2 Pulang Lebih Cepat 3/3 Ijin Sakit 2/3,4/3 TerimakasihTjahya | #yiv0617635601 #yiv0617635601 -- #yiv0617635601ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0617635601 #yiv0617635601ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0617635601 #yiv0617635601ygrp-mkp #yiv0617635601hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0617635601 #yiv0617635601ygrp-mkp #yiv0617635601ads {margin-bottom:10px;}#yiv0617635601 #yiv0617635601ygrp-mkp .yiv0617635601ad {padding:0 0;}#yiv0617635601 #yiv0617635601ygrp-mkp .yiv0617635601ad p {margin:0;}#yiv0617635601 #yiv0617635601ygrp-mkp .yiv0617635601ad a {color:#0000ff;text-decoration:none;}#yiv0617635601 #yiv0617635601ygrp-sponsor #yiv0617635601ygrp-lc {font-family:Arial;}#yiv0617635601 #yiv0617635601ygrp-sponsor #yiv0617635601ygrp-lc #yiv0617635601hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0617635601 #yiv0617635601ygrp-sponsor #yiv0617635601ygrp-lc .yiv0617635601ad {margin-bottom:10px;padding:0 0;}#yiv0617635601 #yiv0617635601actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0617635601 #yiv0617635601activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0617635601 #yiv0617635601activity span {font-weight:700;}#yiv0617635601 #yiv0617635601activity span:first-child {text-transform:uppercase;}#yiv0617635601 #yiv0617635601activity span a {color:#5085b6;text-decoration:none;}#yiv0617635601 #yiv0617635601activity span span {color:#ff7900;}#yiv0617635601 #yiv0617635601activity span .yiv0617635601underline {text-decoration:underline;}#yiv0617635601 .yiv0617635601attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0617635601 .yiv0617635601attach div a {text-decoration:none;}#yiv0617635601 .yiv0617635601attach img {border:none;padding-right:5px;}#yiv0617635601 .yiv0617635601attach label {display:block;margin-bottom:5px;}#yiv0617635601 .yiv0617635601attach label a {text-decoration:none;}#yiv0617635601 blockquote {margin:0 0 0 4px;}#yiv0617635601 .yiv0617635601bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0617635601 .yiv0617635601bold a {text-decoration:none;}#yiv0617635601 dd.yiv0617635601last p a {font-family:Verdana;font-weight:700;}#yiv0617635601 dd.yiv0617635601last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0617635601 dd.yiv0617635601last p span.yiv0617635601yshortcuts {margin-right:0;}#yiv0617635601 div.yiv0617635601attach-table div div a {text-decoration:none;}#yiv0617635601 div.yiv0617635601attach-table {width:400px;}#yiv0617635601 div.yiv0617635601file-title a, #yiv0617635601 div.yiv0617635601file-title a:active, #yiv0617635601 div.yiv0617635601file-title a:hover, #yiv0617635601 div.yiv0617635601file-title a:visited {text-decoration:none;}#yiv0617635601 div.yiv0617635601photo-title a, #yiv0617635601 div.yiv0617635601photo-title a:active, #yiv0617635601 div.yiv0617635601photo-title a:hover, #yiv0617635601 div.yiv0617635601photo-title a:visited {text-decoration:none;}#yiv0617635601 div#yiv0617635601ygrp-mlmsg #yiv0617635601ygrp-msg p a span.yiv0617635601yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0617635601 .yiv0617635601green {color:#628c2a;}#yiv0617635601 .yiv0617635601MsoNormal {margin:0 0 0 0;}#yiv0617635601 o {font-size:0;}#yiv0617635601 #yiv0617635601photos div {float:left;width:72px;}#yiv0617635601 #yiv0617635601photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0617635601 #yiv0617635601photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0617635601 #yiv0617635601reco-category {font-size:77%;}#yiv0617635601 #yiv0617635601reco-desc {font-size:77%;}#yiv0617635601 .yiv0617635601replbq {margin:4px;}#yiv0617635601 #yiv0617635601ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0617635601 #yiv0617635601ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0617635601 #yiv0617635601ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0617635601 #yiv0617635601ygrp-mlmsg select, #yiv0617635601 input, #yiv0617635601 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0617635601 #yiv0617635601ygrp-mlmsg pre, #yiv0617635601 code {font:115% monospace;}#yiv0617635601 #yiv0617635601ygrp-mlmsg * {line-height:1.22em;}#yiv0617635601 #yiv0617635601ygrp-mlmsg #yiv0617635601logo {padding-bottom:10px;}#yiv0617635601 #yiv0617635601ygrp-msg p a {font-family:Verdana;}#yiv0617635601 #yiv0617635601ygrp-msg p#yiv0617635601attach-count span {color:#1E66AE;font-weight:700;}#yiv0617635601 #yiv0617635601ygrp-reco #yiv0617635601reco-head {color:#ff7900;font-weight:700;}#yiv0617635601 #yiv0617635601ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0617635601 #yiv0617635601ygrp-sponsor #yiv0617635601ov li a {font-size:130%;text-decoration:none;}#yiv0617635601 #yiv0617635601ygrp-sponsor #yiv0617635601ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0617635601 #yiv0617635601ygrp-sponsor #yiv0617635601ov ul {margin:0;padding:0 0 0 8px;}#yiv0617635601 #yiv0617635601ygrp-text {font-family:Georgia;}#yiv0617635601 #yiv0617635601ygrp-text p {margin:0 0 1em 0;}#yiv0617635601 #yiv0617635601ygrp-text tt {font-size:120%;}#yiv0617635601 #yiv0617635601ygrp-vital ul li:last-child {border-right:none !important;}#yiv0617635601