5 Ways to Convert Date to Week Number of Month in Excel · =WEEKNUM(B5,1)-WEEKNUM(DATE(YEAR(B5),MONTH(B5),1),1)+1 · =ISOWEEKNUM(B5)-ISOWEEKNUM(DATE(YEAR(B5),MONTH( ...
確定! 回上一頁