假设日期在A1,=INT(DATEDIF(A1,today(),"d")/7)&"周"&MOD(DATEDIF(A1,NOW(),"d"),7)&"天"
=int(datedif(指定日期,taday())/7)
=INT(DATEDIF(A1,TODAY(),"d")/7)格式设置为常规。