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列的全部转换。
本文到此分享完毕，希望对大家有所帮助。

excel阳历农历转换 excel公历转换成农历

推荐阅读

英雄联盟国服排名前五大区lol全服大区实力排行

雁塔题名的典故

抖音退货运费险退到哪里

裙带菜厚蛋烧的做法步骤

杭州哪个地铁站离灵隐寺比较近杭州地铁哪一站离灵隐寺最近

京牌名酒北京二锅头

关于有孔虫石灰岩简述有孔虫石灰岩

王者荣耀技能边框美化攻略-技能边框怎么弄[多图]

王者荣耀不同系统能搜索到名字吗王者不同系统可以搜索到好友吗

男人喝什么茶好处最多男人喝哪些茶好处最多

高情商技巧聊天高情商聊天教程

天天酷跑紫翼神龙觉醒爆分组合推荐[图]

茉莉花需要经常浇水吗

阴历五月十三阳历是什么星座？

男孩子好听的乳名及其寓意

大众途昂和探险者买探险者还是大众途昂

关于爱上你是我一辈子的幸福简述爱上你是我一辈子的幸福

哈罗单车付款页面在哪

随州周边旅游景点简介随州周边旅游景点简介介绍

免打扰模式电话能打进来吗免打扰模式电话能不能打进来