換成月數與天數 (9026)


C2=TEXT(DOLLARFR(B2/30,30)/1%,"0個月00天")


D2=TEXT(INT(B2/30),"0個月;;")&TEXT(MOD(B2,30),"0天;;")


計算周與天數  30改7


留言