距今幾年月日 0為空白且英文表示 (14015)

C2=TEXT(DATEDIF(B2,E$2,"y"),"0!y!ea!r!s ;;")&TEXT(DATEDIF(B2,E$2,"ym"),"0!m!o!nt!h!s ;;")&TEXT(DATEDIF(B2,E$2,"md"),"0!da!y!s;;")

G2=TEXT(DATEDIF(B2,E$2,"y"),"0年 ;;")&TEXT(DATEDIF(B2,E$2,"ym"),"0月 ;;")&TEXT(DATEDIF(B2,E$2,"md"),"0日;;")



留言