excel二进制表格

竭诚为您提供优质文档/双击可除

excel二进制表格

篇一：excel公历转农历的四种方法

excel公历转农历的四种方法

excel公历转农历方法一：使用text函数

a列是公历日期，我们在b1单元格输入公式：

=text(a1,"[$-130000]yyyy年m月"获取当前系统时间curtime=xx_date

天干名称

tiangan(0)="甲"

tiangan(1)="乙"

tiangan(2)="丙"

tiangan(3)="丁"

tiangan(4)="戊"

tiangan(5)="己"

tiangan(6)="庚"

tiangan(7)="辛"

tiangan(8)="壬"

tiangan(9)="癸"

地支名称

dizhi(0)="子"

dizhi(1)="丑"

dizhi(2)="寅"

dizhi(3)="卯"

dizhi(4)="辰"

dizhi(5)="巳"

dizhi(6)="午"dizhi(7)="未"dizhi(8)="申

"dizhi(9)="酉"dizhi(10)="戌"dizhi(11)="亥"属相名称shuxiang(0)="鼠"shuxiang(1)="牛"shuxiang(2)="虎"shuxiang(3)="兔"shuxiang(4)="龙"shuxiang(5)="蛇"shuxiang(6)="马"shuxiang(7)="羊"shuxiang(8)="猴"shuxiang(9)="鸡"shuxiang(10)="狗"shuxiang(11)="猪"农历日期名

dayname(0)="*"dayname(1)="初一"dayname(2)="初二"dayname(3)="初三"dayname(4)="初四"dayname(5)="初五"dayname(6)="初六"dayname(7)="初七"dayname(8)="初八"dayname(9)="初九"dayname(10)="初十"dayname(11)="十一"dayname(12)="十二"dayname(13)="十三

"dayname(14)="十四"dayname(15)="十五"dayname(16)="

十六"dayname(17)="十七"dayname(18)="十八"dayname(19)="十九"dayname(20)="二十"dayname(21)="廿一"dayname(22)="廿二"dayname(23)="廿三"

dayname(24)="廿四"dayname(25)="廿五

"dayname(26)="廿六"dayname(27)="廿七"dayname(28)="廿八"dayname(29)="廿九"dayname(30)="三十"农历月份名monname(0)="*"monname(1)="正"monname(2)="二"monname(3)="三"monname(4)="四"monname(5)="五"monname(6)="六"monname(7)="七"monname(8)="八"monname(9)="九"monname(10)="十"monname(11)="十一"monname(12)="腊"公历每月前面的天数

monthadd(0)=0monthadd(1)=31monthadd(2)=59monthadd(3 )=90monthadd(4)=120monthadd(5)=151monthadd(6)=181mo nthadd(7)=212monthadd(8)=243monthadd(9)=273monthadd (10)=304monthadd(11)=334农历数据

nonglidata(0)=2635nonglidata(1)=333387nonglidata(2) =1701nonglidata(3)=1748nonglidata(4)=267701nonglida ta(5)=694nonglidata(6)=2391nonglidata(7)=133423nong lidata(8)=1175

nonglidata(9)=396438nonglidata(10)=3402nonglidata(1

1)=3749nonglidata(12)=331177nonglidata(13)=1453nong lidata(14)=694nonglidata(15)=20xx26nonglidata(16)=2 350nonglidata(17)=465197nonglidata(18)=3221nonglida ta(19)=3402nonglidata(20)=400202nonglidata(21)=2901 nonglidata(22)=1386nonglidata(23)=267611nonglidata( 24)=605nonglidata(25)=2349nonglidata(26)=137515nong lidata(27)=2709nonglidata(28)=464533nonglidata(29)= 1738nonglidata(30)=2901nonglidata(31)=330421nonglid ata(32)=1242nonglidata(33)=2651nonglidata(34)=19925 5nonglidata(35)=1323nonglidata(36)=529706nonglidata (37)=3733nonglidata(38)=1706nonglidata(39)=398762no nglidata(40)=2741nonglidata(41)=1206nonglidata(42)= 267438nonglidata(43)=2647nonglidata(44)=1318nonglid ata(45)=204070nonglidata(46)=3477nonglidata(47)=461 653nonglidata(48)=1386nonglidata(49)=2413nonglidata (50)=330077nonglidata(51)=1197nonglidata(52)=2637

篇二：电子表格常用函数公式

电子表格常用函数公式

1．去掉最高最低分函数公式：

=sum（所求单元格注：可选中拖动）—max（所选单元格注：可选中拖动）—min（所求单元格注：可选中拖动）（说明：“sum”是求和函数，“max”表示最大值，“min”