=IF(MOD(MID(D2,17,1),2),"男","女")
=TEXT(MID(D2,7,8),"0-00-00")
=INT((TODAY()-D2)/365)
=EDATE(D2,IF(C2="女",55*12,60*12))
=MID("猴鸡狗猪鼠牛虎兔龙蛇马羊",MOD(MID(B2,7,4),12)+1,1)
=LOOKUP(--TEXT(D3,"MDD"),{101,"摩羯座";120,"水瓶座";219,"双鱼座";321,"白羊座";420,"金牛座";542,"双子座";621,"巨蟹座";723,"狮子座";823,"处女座";923,"天秤座";1023,"天蝎座";1122,"射手座";1222,"摩羯座”"})
=COUNTIF(D:D,"本科") |
|