excel 农历转阳历
答案:1 悬赏:0 手机版
解决时间 2021-10-14 10:48
- 提问者网友：人傍凄凉立暮秋
- 2021-10-13 20:45
excel 农历转阳历
最佳答案
- 五星知识达人网友：夜余生
- 2021-10-13 21:21
比如数据在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列的全部转换
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯