入职周年纪念日自动提醒

方能

各位大神：
  请教以下问题，用公式如何实现？

   谢谢大家了。

提兜提戴

入职日期在C2：
=TEXT(ABS(TODAY()-(TEXT(TODAY(),"e/")&TEXT(C2,"m/d"))),"[<11]距离周年纪念日还有0天;")

海是蓝的

感谢
还有个问题，就是正好是入职纪念日的，显示“今天是您入职13周年纪念日。”

青煙袅袅

=IF(TEXT(TODAY(),"m/d")=TEXT(C2,"m/d"),"今天是您入职"&TEXT(TODAY(),"e")-TEXT(C2,"e")&"周年纪念日","")

風雪狼嚎

楼上大佬的好简单，我的超长直译公式献丑了哈哈哈（我只是来回个贴瞅瞅自己的积分）
=IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))-TODAY()>10,"",IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))=TODAY(),TEXT(DATEDIF(B2,TODAY(),"Y"),"今天是您入职0周年纪念日;"),IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))<TODAY(),"",TEXT(DATEDIF(TODAY(),DATE(YEAR(TODAY()),MONTH(B2),DAY(B2)),"D"),"距离周年纪念日还有0天;"))))

悠悠的云彩

感谢你，你这这个虽然长，但是我看懂了。

云的轮廓

大佬，好像不行呢，纪念日当天没有问题了，但是又不能提前提示了，

之之

设日期在B2，C2：=IFERROR(TEXT(TEXT(TEXT(B2,"m-d")-TEXT(TODAY(),"m-d"),"[=0]今天是您入职"&DATEDIF(B2,TODAY(),"y")&"周年纪念日;[<11]0"),"距离周年纪念日还有0天;;;@"),"")

百葉窗

问题已解决，感谢沈水之阳感谢花花爱吃肥肉
=IF(TEXT(TODAY(),"m/d")=TEXT(C2,"m/d"),"今天是您入职"&TEXT(TODAY(),"e")-TEXT(C2,"e ")&"周年纪念日",TEXT(ABS(TODAY()-(TEXT(TODAY(),"e/")&TEXT(C2,"m/d"))),"[<11]距离周年纪念日还有0天;"))