提到生日一般历仍是阳历阴历六月是啥星座阴历7月20是什么星座阴历八月十九是什么星座阴历阳历生日怎样分,我们都知道,有人问阴历与阳历的生日转化,别的,还有人想问阳历生日转化阴历生日,这是怎样回事?其实关于生日阴历阳历转化,下面就一起来看看如安在excel表阴历生量转化成阳历,期望可以协助到我们!
生日一般历仍是阳历阴历六月是啥星座阴历7月20是什么星座阴历八月十九是什么星座阴历阳历生日怎样分
将下面面这段代码保存在模块中,就可以用公式 =nongli(A1) 调用了。
Public Function NongLi(Optional XX_DATE As Date)
Dim MonthAdd(11), NongliData(99), TianGan(9), DiZhi(11), ShuXiang(11), DayName(30), MonName(12)生日是历仍是阳历。
Dim curTime, curYear, curMonth, curDay
Dim GongliStr, NongliStr, NongliDayStr
Dim i, m, n, k, isEnd, bit, TheDate生日是按阴历仍是阳历。
‘获取当时体系时刻
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) = “初8221;
DayName(10) = “初十 “
DayName(11) = “十一”
DayName(12) = “十二”天秤座。
DayName(13) = “十三”
DayName(14) = “十四”
DayName(15) = “十五”白羊座。
DayName(16) = “十六”水瓶座。
DayName(17) = “十七”双鱼座。
DayName(18) = “十八”
DayName(19) = “十8221;生日历仍是阳历好。
DayName(20) = “二8221;生日历仍是阳历。
DayName(21) = “廿一”阳历转阴历生日查询器。
DayName(22) = “廿二”
DayName(23) = “廿三”
DayName(24) = “廿四”
DayName(25) = “廿五”
DayName(26) = “廿六”
DayName(27) = “廿七”
DayName(28) = “廿八”
DayName(29) = “廿8221;
DayName(30) = “三8221;
‘阴历月份名
MonName(0) = “”
MonName(1) = “正”
MonName(2) = “二”
关于生日阴历阳历转化
MonName(3) = “三”
MonName(4) = “四”
MonName(5) = “五”
MonName(6) = “六”
MonName(7) = “七”
MonName(8) = “八”
MonName(9) = “8221;
MonName(10) = “8221;
MonName(11) = “十一”
MonName(12) = “腊”
‘公历每月前面的天数
MonthAdd(0) = 0
MonthAdd(1) = 31
MonthAdd(2) = 59
MonthAdd(3) = 90
MonthAdd(4) = 120
MonthAdd(5) = 151
MonthAdd(6) = 181
MonthAdd(7) = 212
MonthAdd(8) = 243
MonthAdd(9) = 273
MonthAdd(10) = 304
MonthAdd(11) = 334
‘阴历数据
NongliData(0) = 2635
NongliData(1) =
NongliData(2) = 1701
NongliData(3) = 1748
NongliData(4) =
NongliData(5) = 694
NongliData(6) = 2391
NongliData(7) =
NongliData(8) = 1175
NongliData(9) =
NongliData(10) = 3402
NongliData(11) = 3749
NongliData(12) =
NongliData(13) = 1453
NongliData(14) = 694
NongliData(15) =
NongliData(16) = 2350
NongliData(17) =
NongliData(18) = 3221
NongliData(19) = 3402
NongliData(20) =
NongliData(21) = 2901
NongliData(22) = 1386
NongliData(23) =
NongliData(24) = 605
NongliData(25) = 2349
NongliData(26) =
NongliData(27) = 2709
NongliData(28) =
NongliData(29) = 1738
NongliData(30) = 2901
NongliData(31) =
NongliData(32) = 1242
NongliData(33) = 2651
阴历与阳历的生日转化
NongliData(34) =
NongliData(35) = 1323
NongliData(36) =
NongliData(37) = 3733
NongliData(38) = 1706
NongliData(39) =
NongliData(40) = 2741
NongliData(41) = 1206
NongliData(42) =
NongliData(43) = 2647
NongliData(44) = 1318
NongliData(45) =
NongliData(46) = 3477
NongliData(47) =
NongliData(48) = 1386
NongliData(49) = 2413
NongliData(50) =
NongliData(51) = 1197
NongliData(52) = 2637
NongliData(53) =
NongliData(54) = 3365
NongliData(55) =
NongliData(56) = 2900
NongliData(57) = 2922
NongliData(58) =
NongliData(59) = 2395
NongliData(60) = 1179
NongliData(61) =
NongliData(62) = 2635
NongliData(63) =
NongliData(64) = 1701
NongliData(65) = 1748
NongliData(66) =
NongliData(67) = 2742
NongliData(68) = 2391
NongliData(69) =
NongliData(70) = 1175
NongliData(71) = 1611
NongliData(72) =
NongliData(73) = 3749
NongliData(74) =
NongliData(75) = 1452
NongliData(76) = 2742
NongliData(77) =
NongliData(78) = 2350
NongliData(79) = 3222
NongliData(80) =
NongliData(81) = 3402
NongliData(82) = 3493
NongliData(83) =
NongliData(84) = 1386
NongliData(85) =
NongliData(86) = 605
NongliData(87) = 2349
NongliData(88) =
NongliData(89) = 2709
NongliData(90) = 2890
NongliData(91) =
NongliData(92) = 2773
NongliData(93) =
NongliData(94) = 1210
NongliData(95) = 2651
NongliData(96) =
NongliData(97) = 1323
NongliData(98) = 2707
NongliData(99) =
‘生成当时公历年、月、日 ==> GongliStr
curYear = Year(curTime)
curMonth = Month(curTime)
curDay = Day(curTime)
GongliStr = curYear
随机文章: