距生日天數 (13379)

C2=IF(TEXT(B2,"M/D")-E$2>0,TEXT(B2,"M/D")-E$2,IF(TEXT(B2,"M/D")-E$2=0,"今天",((TEXT(B2,"M/D")-E$2<0)+YEAR(E$2)&"/"&TEXT(B2,"M/D"))-E$2))

另解=TEXT(LOOKUP(1,0/(DATE(YEAR(E$2)+{1,0},MONTH(B2),DAY(B2))-E$2>=0),DATE(YEAR(E$2)+{1,0},MONTH(B2),DAY(B2))-E$2),"0;;今天")

另解{=TEXT(EDATE(B2,MATCH(1=1,EDATE(B2,ROW($1:$120)*12)-E$2>=0,)*12)-E$2,"0;;今天")