2021版,在H2中输入或复制粘贴下列公式
=TEXTJOIN("",,DATEDIF(TODAY(),G2,{"Y","YM","MD"})&{"年","月","日"})
或
=DATEDIF(TODAY(),G3,{"Y","YM","MD"})&{"年","月","日"}
下拉填充
通用版本,可用如下公式
=DATEDIF(TODAY(),G3,"Y")"年"&DATEDIF(TODAY(),G3,"YM")&"月"&DATEDIF(TODAY(),G3,"MD")&"日"
追问您看下我这是哪里出了问题