Excel公式自动统计月内第几周,经典日期函数大展身手
Excel公式自动统计月内第几周,经典日期函数大展身手
==============================================================================================================
=MONTH(A2)&TEXT(WEEKNUM(A2,2)-WEEKNUM(A2+1-DAY(A2),2)+1,"月第0周")
==============================================================================================================
=MONTH(A2)&TEXT(WEEKNUM(A2,2)-WEEKNUM(A2+1-DAY(A2),2)+1,"月第0周")