di cell yang ingin anda munculkan hari, format cell dengan custom format cell
menjadi "DDDD" tanpa tanda "".setelah itu manfaatkan fungsi DATE pada cell yang
akan anda munculkan hari. br,
odong nando
Dari: "'Darto Chandra' [email protected] [belajar-excel]"
<[email protected]>
Kepada: [email protected]
Dikirim: Kamis, 29 September 2016 21:33
Judul: [belajar-excel] Menampilkan nama hari sesuai tanggal [1 Attachment]
Mohon petunjuk, bagaimana memunculkan nama hari di kolom warna kuning pada
file terlampir. Terima kasih Darto Chandra #yiv0930257931 #yiv0930257931 --
#yiv0930257931ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}#yiv0930257931 #yiv0930257931ygrp-mkp hr {border:1px solid
#d8d8d8;}#yiv0930257931 #yiv0930257931ygrp-mkp #yiv0930257931hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0930257931 #yiv0930257931ygrp-mkp #yiv0930257931ads
{margin-bottom:10px;}#yiv0930257931 #yiv0930257931ygrp-mkp .yiv0930257931ad
{padding:0 0;}#yiv0930257931 #yiv0930257931ygrp-mkp .yiv0930257931ad p
{margin:0;}#yiv0930257931 #yiv0930257931ygrp-mkp .yiv0930257931ad a
{color:#0000ff;text-decoration:none;}#yiv0930257931 #yiv0930257931ygrp-sponsor
#yiv0930257931ygrp-lc {font-family:Arial;}#yiv0930257931
#yiv0930257931ygrp-sponsor #yiv0930257931ygrp-lc #yiv0930257931hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0930257931
#yiv0930257931ygrp-sponsor #yiv0930257931ygrp-lc .yiv0930257931ad
{margin-bottom:10px;padding:0 0;}#yiv0930257931 #yiv0930257931actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0930257931
#yiv0930257931activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0930257931
#yiv0930257931activity span {font-weight:700;}#yiv0930257931
#yiv0930257931activity span:first-child
{text-transform:uppercase;}#yiv0930257931 #yiv0930257931activity span a
{color:#5085b6;text-decoration:none;}#yiv0930257931 #yiv0930257931activity span
span {color:#ff7900;}#yiv0930257931 #yiv0930257931activity span
.yiv0930257931underline {text-decoration:underline;}#yiv0930257931
.yiv0930257931attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0930257931 .yiv0930257931attach div a
{text-decoration:none;}#yiv0930257931 .yiv0930257931attach img
{border:none;padding-right:5px;}#yiv0930257931 .yiv0930257931attach label
{display:block;margin-bottom:5px;}#yiv0930257931 .yiv0930257931attach label a
{text-decoration:none;}#yiv0930257931 blockquote {margin:0 0 0
4px;}#yiv0930257931 .yiv0930257931bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0930257931
.yiv0930257931bold a {text-decoration:none;}#yiv0930257931 dd.yiv0930257931last
p a {font-family:Verdana;font-weight:700;}#yiv0930257931 dd.yiv0930257931last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0930257931
dd.yiv0930257931last p span.yiv0930257931yshortcuts
{margin-right:0;}#yiv0930257931 div.yiv0930257931attach-table div div a
{text-decoration:none;}#yiv0930257931 div.yiv0930257931attach-table
{width:400px;}#yiv0930257931 div.yiv0930257931file-title a, #yiv0930257931
div.yiv0930257931file-title a:active, #yiv0930257931
div.yiv0930257931file-title a:hover, #yiv0930257931 div.yiv0930257931file-title
a:visited {text-decoration:none;}#yiv0930257931 div.yiv0930257931photo-title a,
#yiv0930257931 div.yiv0930257931photo-title a:active, #yiv0930257931
div.yiv0930257931photo-title a:hover, #yiv0930257931
div.yiv0930257931photo-title a:visited {text-decoration:none;}#yiv0930257931
div#yiv0930257931ygrp-mlmsg #yiv0930257931ygrp-msg p a
span.yiv0930257931yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0930257931
.yiv0930257931green {color:#628c2a;}#yiv0930257931 .yiv0930257931MsoNormal
{margin:0 0 0 0;}#yiv0930257931 o {font-size:0;}#yiv0930257931
#yiv0930257931photos div {float:left;width:72px;}#yiv0930257931
#yiv0930257931photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv0930257931
#yiv0930257931photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0930257931
#yiv0930257931reco-category {font-size:77%;}#yiv0930257931
#yiv0930257931reco-desc {font-size:77%;}#yiv0930257931 .yiv0930257931replbq
{margin:4px;}#yiv0930257931 #yiv0930257931ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0930257931 #yiv0930257931ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0930257931
#yiv0930257931ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0930257931
#yiv0930257931ygrp-mlmsg select, #yiv0930257931 input, #yiv0930257931 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0930257931
#yiv0930257931ygrp-mlmsg pre, #yiv0930257931 code {font:115%
monospace;}#yiv0930257931 #yiv0930257931ygrp-mlmsg *
{line-height:1.22em;}#yiv0930257931 #yiv0930257931ygrp-mlmsg #yiv0930257931logo
{padding-bottom:10px;}#yiv0930257931 #yiv0930257931ygrp-msg p a
{font-family:Verdana;}#yiv0930257931 #yiv0930257931ygrp-msg
p#yiv0930257931attach-count span {color:#1E66AE;font-weight:700;}#yiv0930257931
#yiv0930257931ygrp-reco #yiv0930257931reco-head
{color:#ff7900;font-weight:700;}#yiv0930257931 #yiv0930257931ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0930257931 #yiv0930257931ygrp-sponsor
#yiv0930257931ov li a {font-size:130%;text-decoration:none;}#yiv0930257931
#yiv0930257931ygrp-sponsor #yiv0930257931ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0930257931
#yiv0930257931ygrp-sponsor #yiv0930257931ov ul {margin:0;padding:0 0 0
8px;}#yiv0930257931 #yiv0930257931ygrp-text
{font-family:Georgia;}#yiv0930257931 #yiv0930257931ygrp-text p {margin:0 0 1em
0;}#yiv0930257931 #yiv0930257931ygrp-text tt {font-size:120%;}#yiv0930257931
#yiv0930257931ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0930257931
