如题所述
B1公式:
=DATEDIF(DATE(YEAR(A1)-1,12,31),A1,"d")
请点击输入图片描述
C1公式:
=DATEDIF(DATE(YEAR(A1)-1,12,31),DATE(YEAR(A1),12,31),"d")-B1