1. 首頁 > 生活百科 > >

excel陽歷農歷轉換 excel公歷轉換成農歷

知識經驗


excel陽歷農歷轉換 excel公歷轉換成農歷

文章插圖
大家好,小龍來為大家解答以上的問題 。excel公歷轉換成農歷，excel陽歷農歷轉換這個很多人還不知道,現在讓我們一起來看看吧！
【excel陽歷農歷轉換 excel公歷轉換成農歷】1、比如數據在a1在b1輸入=LOOKUP(LEFT(A1,FIND("月",A1,1)-1),{"八","二","九","六","七","三","十","十二","十一","四","五","一"},{8,2,9,6,7,3,10,12,11,4,5,1})&"."&LOOKUP(MID(A1,FIND("月",A1,1)+1,3),{"初八","初二","初九","初六","初七","初三","初十","初四","初五","初一","二十","二十八","二十二","二十九","二十六","二十七","二十三","二十四","二十五","二十一","三十","十八","十二","十九","十六","十七","十三","十四","十五","十一"},{"08","02","09","06","07","03","10","04","05","01","20","28","22","29","26","27","23","24","25","21","30","18","12","19","16","17","13","14","15","11"})選中向下拖就oka列的全部轉換 。
本文到此分享完畢，希望對大家有所幫助 。

    推薦閱讀