Jonathan from the ExcelCentral forums suggests: =WEEKNUM(A1,2)-WEEKNUM(DATE(YEAR(A1),MONTH(A1),1),2)+1. This formula extracts the week of ... ... <看更多>
Search
Search
Jonathan from the ExcelCentral forums suggests: =WEEKNUM(A1,2)-WEEKNUM(DATE(YEAR(A1),MONTH(A1),1),2)+1. This formula extracts the week of ... ... <看更多>