oo... yasudah, bisa dilakukan dengan langsung mengetik operatornya pada sebelum mengetik tgl nya
pada prinsipnya sama dengan melakukan advanced filter dengan number biasa. lebih lengkap bisa kunjungi support office https://support.office.com/en-us/article/Filter-by-using-advanced-criteria-4c9222fe-8529-4cd7-a898-3f16abdff32b br, odong nando Pada Kamis, 12 November 2015 13:42, "Bambang Setiawan [email protected] [belajar-excel]" <[email protected]> menulis: On 11/12/2015 12:30 PM, odong nando [email protected] [belajar-excel] wrote: yoo p bambang, klo menurut saya klo pake advanced filter kayaknya berlebihan, bisa dicoba pake menggunakan filter biasa aja pak, block data yang akan di filter => plih data filter =>custom filter => ganti equal menjadi kriteria yang kita mau, dalam hal ini "is after or equal to "=> isi dengan nilai 1992-01-01 br, odong nando Dear Pak Odong, Terima kasih untuk responnya pak, memang sebenarnya lebih mudah menggunakan custom filter saja, implementasi sebenarnya bukan untuk table simple seperti yang saya contohkan sih Pak :-) dan saya sedang cari cara gimana melakukan filter jika criteria data type-nya berupa tanggal di advanced filter. Salam, #yiv1473451598 #yiv1473451598 -- #yiv1473451598ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1473451598 #yiv1473451598ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1473451598 #yiv1473451598ygrp-mkp #yiv1473451598hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1473451598 #yiv1473451598ygrp-mkp #yiv1473451598ads {margin-bottom:10px;}#yiv1473451598 #yiv1473451598ygrp-mkp .yiv1473451598ad {padding:0 0;}#yiv1473451598 #yiv1473451598ygrp-mkp .yiv1473451598ad p {margin:0;}#yiv1473451598 #yiv1473451598ygrp-mkp .yiv1473451598ad a {color:#0000ff;text-decoration:none;}#yiv1473451598 #yiv1473451598ygrp-sponsor #yiv1473451598ygrp-lc {font-family:Arial;}#yiv1473451598 #yiv1473451598ygrp-sponsor #yiv1473451598ygrp-lc #yiv1473451598hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1473451598 #yiv1473451598ygrp-sponsor #yiv1473451598ygrp-lc .yiv1473451598ad {margin-bottom:10px;padding:0 0;}#yiv1473451598 #yiv1473451598actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1473451598 #yiv1473451598activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1473451598 #yiv1473451598activity span {font-weight:700;}#yiv1473451598 #yiv1473451598activity span:first-child {text-transform:uppercase;}#yiv1473451598 #yiv1473451598activity span a {color:#5085b6;text-decoration:none;}#yiv1473451598 #yiv1473451598activity span span {color:#ff7900;}#yiv1473451598 #yiv1473451598activity span .yiv1473451598underline {text-decoration:underline;}#yiv1473451598 .yiv1473451598attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1473451598 .yiv1473451598attach div a {text-decoration:none;}#yiv1473451598 .yiv1473451598attach img {border:none;padding-right:5px;}#yiv1473451598 .yiv1473451598attach label {display:block;margin-bottom:5px;}#yiv1473451598 .yiv1473451598attach label a {text-decoration:none;}#yiv1473451598 blockquote {margin:0 0 0 4px;}#yiv1473451598 .yiv1473451598bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1473451598 .yiv1473451598bold a {text-decoration:none;}#yiv1473451598 dd.yiv1473451598last p a {font-family:Verdana;font-weight:700;}#yiv1473451598 dd.yiv1473451598last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1473451598 dd.yiv1473451598last p span.yiv1473451598yshortcuts {margin-right:0;}#yiv1473451598 div.yiv1473451598attach-table div div a {text-decoration:none;}#yiv1473451598 div.yiv1473451598attach-table {width:400px;}#yiv1473451598 div.yiv1473451598file-title a, #yiv1473451598 div.yiv1473451598file-title a:active, #yiv1473451598 div.yiv1473451598file-title a:hover, #yiv1473451598 div.yiv1473451598file-title a:visited {text-decoration:none;}#yiv1473451598 div.yiv1473451598photo-title a, #yiv1473451598 div.yiv1473451598photo-title a:active, #yiv1473451598 div.yiv1473451598photo-title a:hover, #yiv1473451598 div.yiv1473451598photo-title a:visited {text-decoration:none;}#yiv1473451598 div#yiv1473451598ygrp-mlmsg #yiv1473451598ygrp-msg p a span.yiv1473451598yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1473451598 .yiv1473451598green {color:#628c2a;}#yiv1473451598 .yiv1473451598MsoNormal {margin:0 0 0 0;}#yiv1473451598 o {font-size:0;}#yiv1473451598 #yiv1473451598photos div {float:left;width:72px;}#yiv1473451598 #yiv1473451598photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv1473451598 #yiv1473451598photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1473451598 #yiv1473451598reco-category {font-size:77%;}#yiv1473451598 #yiv1473451598reco-desc {font-size:77%;}#yiv1473451598 .yiv1473451598replbq {margin:4px;}#yiv1473451598 #yiv1473451598ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1473451598 #yiv1473451598ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1473451598 #yiv1473451598ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1473451598 #yiv1473451598ygrp-mlmsg select, #yiv1473451598 input, #yiv1473451598 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1473451598 #yiv1473451598ygrp-mlmsg pre, #yiv1473451598 code {font:115% monospace;}#yiv1473451598 #yiv1473451598ygrp-mlmsg * {line-height:1.22em;}#yiv1473451598 #yiv1473451598ygrp-mlmsg #yiv1473451598logo {padding-bottom:10px;}#yiv1473451598 #yiv1473451598ygrp-msg p a {font-family:Verdana;}#yiv1473451598 #yiv1473451598ygrp-msg p#yiv1473451598attach-count span {color:#1E66AE;font-weight:700;}#yiv1473451598 #yiv1473451598ygrp-reco #yiv1473451598reco-head {color:#ff7900;font-weight:700;}#yiv1473451598 #yiv1473451598ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1473451598 #yiv1473451598ygrp-sponsor #yiv1473451598ov li a {font-size:130%;text-decoration:none;}#yiv1473451598 #yiv1473451598ygrp-sponsor #yiv1473451598ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1473451598 #yiv1473451598ygrp-sponsor #yiv1473451598ov ul {margin:0;padding:0 0 0 8px;}#yiv1473451598 #yiv1473451598ygrp-text {font-family:Georgia;}#yiv1473451598 #yiv1473451598ygrp-text p {margin:0 0 1em 0;}#yiv1473451598 #yiv1473451598ygrp-text tt {font-size:120%;}#yiv1473451598 #yiv1473451598ygrp-vital ul li:last-child {border-right:none !important;}#yiv1473451598
