excel中用公式把公司员工今年的农历生日转换成今年的国历日期（做提醒使用）

C2=LOOKUP(--(YEAR(NOW())&TEXT(B2,"-00-00")),--TEXT("1/1"+ROW($1:$400),"[$-130000]yyyy/m/d"),"1/1"+ROW($1:$400))----农历2/29,2/30会错误    

修正：    

D2=LOOKUP(--(YEAR(NOW())&TEXT(B2-OR(B2={"0229","0230"})*2,"-00-00")),--TEXT("1/1"+ROW($1:$400),"[$-130000]yyyy/m/d"),"1/1"+ROW($1:$400))+OR(B2={"0229","0230"})*2