Hai Pujo,Coba perhatikan penulisan tanggalnya, tanggal/bulan/tahun atau
bulan/tanggal tahun.Sesuai saran Mr. Kid, agar bisa dipakai di Region Setting
Indonesia maupun English sebaiknya tanggal ditulis..=Date(Year,Month,Day).
Salam,HK
From: "[email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Monday, 22 February 2016, 10:36
Subject: [belajar-excel] Ubah Tanggal ke Hari [1 Attachment]
Assalamualaikum,
Salam kenal buat rekan-rekan BeExceller, saya baru gabung di group ini.
Mohon bantuannya, saya ada masalah dalam mengubah tanggal ke hari.
sebagian data bisa di rubah ke nama hari, tapi sebagian tanggal tidak bisa di
rubah. mohon pencerahannya, data terlampir.
Regards
Pujo #yiv9556036230 #yiv9556036230 -- #yiv9556036230ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9556036230
#yiv9556036230ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9556036230
#yiv9556036230ygrp-mkp #yiv9556036230hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9556036230 #yiv9556036230ygrp-mkp #yiv9556036230ads
{margin-bottom:10px;}#yiv9556036230 #yiv9556036230ygrp-mkp .yiv9556036230ad
{padding:0 0;}#yiv9556036230 #yiv9556036230ygrp-mkp .yiv9556036230ad p
{margin:0;}#yiv9556036230 #yiv9556036230ygrp-mkp .yiv9556036230ad a
{color:#0000ff;text-decoration:none;}#yiv9556036230 #yiv9556036230ygrp-sponsor
#yiv9556036230ygrp-lc {font-family:Arial;}#yiv9556036230
#yiv9556036230ygrp-sponsor #yiv9556036230ygrp-lc #yiv9556036230hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9556036230
#yiv9556036230ygrp-sponsor #yiv9556036230ygrp-lc .yiv9556036230ad
{margin-bottom:10px;padding:0 0;}#yiv9556036230 #yiv9556036230actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9556036230
#yiv9556036230activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9556036230
#yiv9556036230activity span {font-weight:700;}#yiv9556036230
#yiv9556036230activity span:first-child
{text-transform:uppercase;}#yiv9556036230 #yiv9556036230activity span a
{color:#5085b6;text-decoration:none;}#yiv9556036230 #yiv9556036230activity span
span {color:#ff7900;}#yiv9556036230 #yiv9556036230activity span
.yiv9556036230underline {text-decoration:underline;}#yiv9556036230
.yiv9556036230attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9556036230 .yiv9556036230attach div a
{text-decoration:none;}#yiv9556036230 .yiv9556036230attach img
{border:none;padding-right:5px;}#yiv9556036230 .yiv9556036230attach label
{display:block;margin-bottom:5px;}#yiv9556036230 .yiv9556036230attach label a
{text-decoration:none;}#yiv9556036230 blockquote {margin:0 0 0
4px;}#yiv9556036230 .yiv9556036230bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9556036230
.yiv9556036230bold a {text-decoration:none;}#yiv9556036230 dd.yiv9556036230last
p a {font-family:Verdana;font-weight:700;}#yiv9556036230 dd.yiv9556036230last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9556036230
dd.yiv9556036230last p span.yiv9556036230yshortcuts
{margin-right:0;}#yiv9556036230 div.yiv9556036230attach-table div div a
{text-decoration:none;}#yiv9556036230 div.yiv9556036230attach-table
{width:400px;}#yiv9556036230 div.yiv9556036230file-title a, #yiv9556036230
div.yiv9556036230file-title a:active, #yiv9556036230
div.yiv9556036230file-title a:hover, #yiv9556036230 div.yiv9556036230file-title
a:visited {text-decoration:none;}#yiv9556036230 div.yiv9556036230photo-title a,
#yiv9556036230 div.yiv9556036230photo-title a:active, #yiv9556036230
div.yiv9556036230photo-title a:hover, #yiv9556036230
div.yiv9556036230photo-title a:visited {text-decoration:none;}#yiv9556036230
div#yiv9556036230ygrp-mlmsg #yiv9556036230ygrp-msg p a
span.yiv9556036230yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9556036230
.yiv9556036230green {color:#628c2a;}#yiv9556036230 .yiv9556036230MsoNormal
{margin:0 0 0 0;}#yiv9556036230 o {font-size:0;}#yiv9556036230
#yiv9556036230photos div {float:left;width:72px;}#yiv9556036230
#yiv9556036230photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9556036230
#yiv9556036230photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9556036230
#yiv9556036230reco-category {font-size:77%;}#yiv9556036230
#yiv9556036230reco-desc {font-size:77%;}#yiv9556036230 .yiv9556036230replbq
{margin:4px;}#yiv9556036230 #yiv9556036230ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9556036230 #yiv9556036230ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9556036230
#yiv9556036230ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9556036230
#yiv9556036230ygrp-mlmsg select, #yiv9556036230 input, #yiv9556036230 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9556036230
#yiv9556036230ygrp-mlmsg pre, #yiv9556036230 code {font:115%
monospace;}#yiv9556036230 #yiv9556036230ygrp-mlmsg *
{line-height:1.22em;}#yiv9556036230 #yiv9556036230ygrp-mlmsg #yiv9556036230logo
{padding-bottom:10px;}#yiv9556036230 #yiv9556036230ygrp-msg p a
{font-family:Verdana;}#yiv9556036230 #yiv9556036230ygrp-msg
p#yiv9556036230attach-count span {color:#1E66AE;font-weight:700;}#yiv9556036230
#yiv9556036230ygrp-reco #yiv9556036230reco-head
{color:#ff7900;font-weight:700;}#yiv9556036230 #yiv9556036230ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9556036230 #yiv9556036230ygrp-sponsor
#yiv9556036230ov li a {font-size:130%;text-decoration:none;}#yiv9556036230
#yiv9556036230ygrp-sponsor #yiv9556036230ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9556036230
#yiv9556036230ygrp-sponsor #yiv9556036230ov ul {margin:0;padding:0 0 0
8px;}#yiv9556036230 #yiv9556036230ygrp-text
{font-family:Georgia;}#yiv9556036230 #yiv9556036230ygrp-text p {margin:0 0 1em
0;}#yiv9556036230 #yiv9556036230ygrp-text tt {font-size:120%;}#yiv9556036230
#yiv9556036230ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9556036230
