EXCEL函數-週六日假日變色(1602) @ EXCEL迷

2D 大心國際 多媒體行銷 SEO關鍵字流量 多媒體行銷 AR全息投影

B1:AF1=IF(MONTH(--($A1&"/1")+COLUMN(A1)-1)=$A1,COLUMN(A1),"")

B2:AF2=IF(B1="","",RIGHT(TEXT(WEEKDAY($A1&"/"&B1,1),"AAA")))

格式化-->圈選B1:AF2-->公式=(B$2="六")+(B$2="日")+(COUNTIF($AH$2:$AH$13,$A$1&"/"&B$1)>0)

格式化-->圈選AH2:AH13-->公式=MONTH(AH2)=$A$1

產品 品牌 托播廣告 廣告托播 托播廣告 SEO網站優化 (function(){$('#content_all img').map((function(){var skip_count = 2;return function(){var $this = $(this);if(this.src.indexOf('.gif') == -1) {var data = {title: this.title || this.alt || '',description: '',src: this.src,size: 'o',href: $this.parent('a')};if(data.href.length != 0) {data.href = data.href[0].href;} else {data.href = '#';}if(skip_count <= 0) {var src = this.src;$(this).addClass('lazyload').attr({'src': 'data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7','data-original': src});} else {skip_count--;}}return this;};})());$(function(){$('#content_all img.lazyload').lazyload({threshold: 600,load: function() {$(this).removeClass('lazyload');if( BlogPlugins && BlogPlugins.auto_resize &&(typeof xuiteBlogPlugin_auto_resize=="undefined") || (xuiteBlogPlugin_auto_resize == null) || (xuiteBlogPlugin_auto_resize == 'Y') ) {BlogPlugins.auto_resize(this, null, {delay:1000});}}});});})();var itemArticleDetailType = "";if(getCookie("xuite_id") != null && itemArticleDetailType != "article_preview"){$.ajax({type: "GET",url: "/_theme/AuthorButtonExp.php?aid=326221281&bid=3634078&mid=238722711&author_id=238722711&article_type=blog&ga="+(new Date()).getTime(),async: false,dataType: 'json',success: getButton});}function getButton(json){document.write(" "+json+" ");}if ((typeof xuiteBlogPlugin_auto_yo=="undefined") || (xuiteBlogPlugin_auto_yo == null) || (xuiteBlogPlugin_auto_yo == 'Y')) {$.ajax({type: "GET",url: "//s.blog.xuite.net/_public/js/BlogPlugins.auto_yo.js",success: function(){BlogPlugins.auto_yo.fetchItem(326221281);},dataType: "script",cache: true});} if ((typeof xuiteBlogPlugin_bookmark=="undefined") || (xuiteBlogPlugin_bookmark == null) || (xuiteBlogPlugin_bookmark == 'Y')){document.write(" ");(new XUI.Widgets.Push($(".bookmark"))).render();} if ((typeof xuiteBlogPlugin_facebook_comment=="undefined") || (xuiteBlogPlugin_facebook_comment == null) || (xuiteBlogPlugin_facebook_comment == 'Y')){var myBlogThemeWidth = $(".title").width()-38;if ((typeof xuiteBlogPlugin_facebook_comment_color=="undefined") || (xuiteBlogPlugin_facebook_comment_color == null) || (xuiteBlogPlugin_facebook_comment_color == 'Y')){document.write(' '+' ');}else {document.write(' '+' ');}(function(d, s, id) {var js, fjs = d.getElementsByTagName(s)[0];if (d.getElementById(id)) return;js = d.createElement(s); js.id = id;js.src = "//connect.facebook.net/zh_TW/sdk.js#xfbml=1&version=v2.0";fjs.parentNode.insertBefore(js, fjs);}(document, 'script', 'facebook-jssdk'));}if ((typeof xuiteBlogPlugin_facebook_like_down == "undefined") || (xuiteBlogPlugin_facebook_like_down == null) || (xuiteBlogPlugin_facebook_like_down == 'Y')){$(document).ready(function(){(new XUI.Widgets.Like(document.getElementById('facebook-like-bottom'), { mode : 'face' , URL : 'http://blog.xuite.net/hcm19522/twblog/326221281' })).render();});} var notVIP = ' ';$(".articleExtAd").append(notVIP);setTimeout(function() {$('.top-toolbar').data('top-toolbar').setAD({title: "EXCEL\u51fd\u6578-\u9031\u516d\u65e5 \u5047\u65e5\u8b8a\u8272 (1602)",label_id: 164,label_name: "\u8edf\u9ad4\u60c5\u5831"});}, 2000); if( (typeof xuiteBlogPlugin_random_article=="undefined") || (xuiteBlogPlugin_random_article == null) || (xuiteBlogPlugin_random_article == 'Y') || (xuiteBlogPlugin_random_article == 'YY') ){$(".articleExt").append(' ');var random_content = ' ';$(".articleExt").append(random_content);$.get("/_theme/ArticleRandomExp.php?bid=3634078&plugin_random="+xuiteBlogPlugin_random_article+"&theme_type=&tpl_type=1", function(data){$("#articleExt_random_content").append(data);if(data != null && data != ""){$("#articleExt_random_title").append("隨機文章 : ");if(xuiteBlogPlugin_random_article == "YY"){$("ul#articleExt_random_content").attr("class","");}}});}if( (typeof xuiteBlogPlugin_relate_article=="undefined") || (xuiteBlogPlugin_relate_article == null) || (xuiteBlogPlugin_relate_article == 'Y')){$(".articleExt").append(' ');}else{$(".articleExt").append(' ');}if( (typeof xuiteBlogPlugin_history_today=="undefined") || (xuiteBlogPlugin_history_today == null) || (xuiteBlogPlugin_history_today == 'Y')){$(".articleExt").append(" 歷史上的今天: 车辆下次审验日期 (5855) (2019-07-16) 提取唯一值并统计总个数 (5854) (2019-07-16) 提取不重复数值且没空格 (5853) (2019-07-16) 快遞計價 (4715) (2018-07-16) 找關鍵字相同最多简称 (4714) (2018-07-16) 多条件查询引用COUNTIF( ~ , (2018-07-16) 随机数字不能重复 (4712) (2018-07-16) 計算投注理賠率 (4711) (2018-07-16) 特定文字 整橫列會變色 (4710) (2018-07-16) 每個工作性質有二人 ,即二人平分 ,統計每人對各工作性質總金額 (3381) (2017-07-16) ");}(function() {var pa = document.createElement('script'); pa.type = 'text/javascript'; pa.charset = "utf-8"; pa.async = true;pa.src = window.location.protocol + "//api.popin.cc/searchbox/xuite_blog.js";var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(pa, s);})(); hcm19522 / Xuite日誌 / 回應(0) / 引用(0) 沒有上一則| 日誌首頁 |沒有下一則 回應 function wopen(){ window.open("//blog.xuite.net/_theme/item/item_auto_trackback.php?ping=https://blog.xuite.net/hcm19522/twblog/326221281/track","trackBack","location=no,toolbar=no,resizable=yes,scrollbars=yes,width=430,height=400") }

function copy_clip(meintext) { if (window.clipboardData) { // the IE-manier window.clipboardData.setData("Text", meintext); } }

function openSpecfiyWindown(windowName){ window.open('about:blank',windowName,'width=800,height=600,menubar=no,scrollbars=yes'); }

function doMsgDelete(mid,page){ if(confirm("是否確定要刪除")){ $("div.jqmWindow").html(" "); } }

function doTrackDelete(tid,lid,url,page){ if(confirm("是否確定要刪除")){ $("div.jqmWindow").html(" "); } }

function doMsgEdit(mid,page){ var l="/_theme/message/message_post.php?act=edit&mid="+mid+"&aid=326221281&bid=3634078&page="+page; window.open(l,'post_win','width=660,height=700,scrollbars=1'); }

function doMsgReplyAdd(rel_id,page,owner_sn,owner_login_id){ var l="/_theme/message/message_post.php?act=reply&rel_id="+rel_id+"&aid=326221281&bid=3634078&page="+page+"&owner_sn="+owner_sn+"&owner_login_id="+owner_login_id; window.open(l,'post_win','width=660,height=700,scrollbars=1'); }

function doMsgReplyEdit(mid,page){ var l="/_theme/message/message_post.php?act=reply_edit&mid="+mid+"&aid=326221281&bid=3634078&page="+page; window.open(l,'post_win','width=660,height=700,scrollbars=1'); }

function doSummary(arg){ $("#summarySwitch").html($("#summaryContent").html()); $("#summaryContent").html($("#summaryDisplay").html()); $("#summaryDisplay").html($("#summarySwitch").html()); }

$(document).ready(function(){ var index=""; Message(326221281,3634078,238722711,238722711,index); TrackBack('326221281','hcm19522','twblog','238722711','3634078','238722711','N',index);

if ((typeof xuiteBlogPlugin_auto_resize=="undefined") || (xuiteBlogPlugin_auto_resize == null) || (xuiteBlogPlugin_auto_resize == 'Y')) { $.ajax({ type: "GET", url: "//s.blog.xuite.net/_public/js/BlogPlugins.auto_resize.js", success: function(){ BlogPlugins.auto_resize("#content_all img", null, {delay:1000}); }, dataType: "script", cache: true }); }

$.ajax({ type: "GET", url: '/_theme/ArticleDetailCounterExp.php?aid=326221281&ga='+(new Date()).getTime(), dataType: 'json', success: getArticleDetailCounter }); });

function getArticleDetailCounter(json){ $("#article_counter").html(json[0].counter);

}

function TrackBack(aid,b_login,b_url,mid,bid,a_author_id,track_flag,index){ $.ajax({ type: "GET", url: '/_theme/TrackBackShowExp.php?aid='+aid+'&b_login='+b_login+'&b_url='+b_url+'&mid='+mid+'&bid='+bid+'&a_author_id='+a_author_id+'&track_flag='+track_flag+'&index='+index+'&ga='+(new Date()).getTime(), dataType: 'json', async: false, success: getTrackBackShow }); }

function getMessageShow(json){ $("div.item_message").html(json['message'].content); $("div.alertLoad").hide(); if(json['aside'].check != 0){ for( i =0; i (這則留言是 悄悄話 ) "); $("div#commenttext_"+json['aside'][i].id).html(json['aside'][i].content); } }

if (json['button'].check != 0){ for( i =0; i "); /*是回應*/ }else{ /*有回覆*/ if($("div#reply_"+json['button'][i].id).html() != null){ $("div#commentbutton_"+json['button'][i].id).html(" "); /*沒回覆*/ }else{ if(json['button'][i].self_write != 'y'){ $("div#commentbutton_"+json['button'][i].id).html(" "); }else{ $("div#commentbutton_"+json['button'][i].id).html(" "); } } } }else if(json['button'][i].level == 'one'){ /*是回覆*/ if(json['button'][i].relation_id != null && json['button'][i].relation_id != "undefined"){ $("div#commentbutton_"+json['button'][i].relation_id).html(" "); /*是回應*/ }else{ /*有回覆*/ if($("div#reply_"+json['button'][i].id).html() != null){ $("div#commentbutton_"+json['button'][i].id).html(" "); /*沒回覆*/ }else{ if(json['button'][i].self_write != 'y'){ $("div#commentbutton_"+json['button'][i].id).html(" "); }else{ $("div#commentbutton_"+json['button'][i].id).html(" "); } } } //放上ip }else{ $("div#commentbutton_"+json['button'][i].id).html(" "); } } } if (json['reload'].flage != "true"){ ff= location.href; tt = ff.indexOf("#"); if(tt != -1){ o_index =ff.substring(0,tt); location.href="https://blog.xuite.net/hcm19522/twblog/o_index+"#message_header"; }else{ location.href="https://blog.xuite.net/hcm19522/twblog/ff+"#message_header"; } } }

showAbuse : 1,// 檢舉公告, 個人前台才要showAbuse: 1 or 不填(optional)

hideMarketing : 0, // 刊登廣告, hideMarketing: 1 or 不填(optional) hideDeveloper : 1,// 開發者專區(API), 個人前台(personal)才要hideDeveloper:1 or 不填(optional) hidePolicy : 0,// 網站分級, hidePolicy:1 or 不填(optional) hideMobile : 0 // 行動版, hideMobile:1 or 不填(optional) //event帳號底下的活動網站，全都不轉導行動版 });

footer.render(); if(document.all) { (function() { if($('.blogbody').get(0)){ var oObjs = $('.blogbody').get(0).getElementsByTagName('object'), n = oObjs.length; for(var i = 0; i 0)) { var pinnedSite = new XUI.Widgets.PinnedSite(); pinnedSite.render(); }

$(".articleExt").show(); if(!block_flag){ document.getElementsByTagName('head')[0].appendChild(document. createElement('script')).src="https://ad.sitemaji.com/ysm_xuite.js?u="+encodeURIComponent("//p8u.hinet.net/js.ng/affiliate=xuiteblog&site=hinet&spacedesc=blogtabunit&keyword=default"); } (function(){ var breakTime = new XUI.Widgets.BreakTime(document.body, { break_time: 120000 }); breakTime.render(); })();

以下內文出自: https://blog.xuite.net/hcm19522/twblog/326221281-EXCEL%E5%87%BD%E6%95%B8-%E9%80%B1%E5%85%AD%E6%97%A5

3D全息廣告,廣告公司,全息投影

產品,品牌,三維智能,托播廣告

EXCEL函數-週六日假日變色(1602) @ EXCEL迷

hcm19522's 新文章

hcm19522's 新回應

個人資訊

熱門文章

文章分類

最新文章

動態訂閱

文章精選

文章搜尋

誰來我家

參觀人氣