This article describes the formula syntax and usage of the WEEKNUM function in Microsoft Excel. Returns the week number of a specific date. For example, the week containing January 1 is the first week of the year, and is numbered week 1. There are two systems used for this function: