doppia2

天干五合
甲己合化土、乙庚合化金、丙辛合化水、丁壬合化木、戊癸合化火

姓名學著重地支。

三合同陰同陽之合，為五行相生之合。
申、子、辰合水局【龍、鼠、猴】
巳、酉、丑合金局【蛇、雞、牛】
寅、午、戌合火局【虎、馬、狗】
亥、卯、未合木局【豬、兔、羊】

三會同類相聚，為陰陽相吸之會。
亥、子、丑三會北方水
寅、卯、辰三會東方木
巳、午、未三會南方火
申、酉、戌三會西方金

相沖 同陰同陽之沖剋，又稱為正沖、地支六沖；力道大又激烈。
子午相沖 丑未相沖 寅申相沖
卯酉相沖 辰戌相沖 巳亥相沖

相害 又稱相穿、地支六害
子未相害 丑午相害 寅巳相害
卯辰相害 申亥相害 酉戌相害

輸入2017
A2=IF(MOD(C2-1863,10)=1,"甲",IF(MOD(C2-1863,10)=2,"乙",IF(MOD(C2-1863,10)=3,"丙",IF(MOD(C2-1863,10)=4,"丁",IF(MOD(C2-1863,10)=5,"戊",IF(MOD(C2-1863,10)=6,"己",IF(MOD(C2-1863,10)=7,"庚",IF(MOD(C2-1863,10)=8,"辛",IF(MOD(C2-1863,10)=9,"壬",IF(MOD(C2-1863,10)=0,"癸"))))))))))

A3=IF(MOD(C2-1863,12)=1,"子",IF(MOD(C2-1863,12)=2,"丑",IF(MOD(C2-1863,12)=3,"寅",IF(MOD(C2-1863,12)=4,"卯",IF(MOD(C2-1863,12)=5,"辰",IF(MOD(C2-1863,12)=6,"巳",IF(MOD(C2-1863,12)=7,"午",IF(MOD(C2-1863,12)=8,"未",IF(MOD(C2-1863,12)=9,"申",IF(MOD(C2-1863,12)=10,"酉",IF(MOD(C2-1863,12)=11,"戌",IF(MOD(C2-1863,12)=0,"亥"))))))))))))

C2=IF(B4="子","申子辰",IF(B4="丑","巳酉丑",IF(B4="寅","寅戊戌",IF(B4="卯","亥卯未",IF(B4="辰","申子辰",IF(B4="巳","巳酉丑",IF(B4="午","寅戊戌", IF(B4="未","亥卯未",IF(B4="申","申子辰", IF(B4="酉","巳酉丑",IF(B4="戌","寅戊戌", IF(B4="亥","亥卯未"))))))))))))

C3=IF(B4="子","亥子丑",IF(B4="丑","亥子丑",IF(B4="寅","寅卯辰",IF(B4="卯","寅卯辰",IF(B4="辰","寅卯辰",IF(B4="巳","巳午未",IF(B4="午","巳午未", IF(B4="未","巳午未",IF(B4="申","申酉戌", IF(B4="酉","申酉戌",IF(B4="戌","申酉戌", IF(B4="亥","亥子丑"))))))))))))

C4=IF(B4="子","午",IF(B4="丑","未",IF(B4="寅","申",IF(B4="卯","酉",IF(B4="辰","戌",IF(B4="巳","亥",IF(B4="午","子", IF(B4="未","丑",IF(B4="申","寅", IF(B4="酉","卯",IF(B4="戌","辰", IF(B4="亥","巳"))))))))))))

C5=IF(B4="子","未",IF(B4="丑","午",IF(B4="寅","巳",IF(B4="卯","辰",IF(B4="辰","卯",IF(B4="巳","寅",IF(B4="午","丑", IF(B4="未","子",IF(B4="申","亥", IF(B4="酉","戌",IF(B4="戌","酉", IF(B4="亥","申"))))))))))))