Returns a number representing the week of the year where the provided date falls.
SYNTAX: =WEEKNUM(date, [type])
date - The date for which to determine the week number. Must be a reference to a cell containing a date, a function returning a date type or a number.
type - [optional] - A number representing the day that a week starts on. Sunday = 1.
PRACTICE SHEET
The above sheet is view only mode, please make a copy to practice.