生日 日期 (10512)

F2=TEXT(C2-ISERR(-TEXT(C2,"M/D")),"M/D")*1

另解=EDATE(C2,12*(YEAR(TODAY())-YEAR(C2)))

另解=-LOOKUP(,-TEXT(C2,{"2-28","m/d"}))

另解=EDATE(C2,DATEDIF(C2,12&-31,"y")*12)

另解=IFERROR(--TEXT(C2,"m/d"),--"2/28")

另解=-LOOKUP(,-TEXT(C2-{1,0},"m-d"))