Skip to main content

Posts

Showing posts with the label weeknum

Google Sheets - WEEKNUM function

WEEKNUM  function returns the number of week of a date, that is, whether a date is the 5th, or 17th week of a year etc. Syntax WEEKNUM(date, [ type ]) type is optional.  If type is 1, it means the week starts on Sunday. The default value of  type  is 1. If type is 2, it means the week starts on Monday.  If  type  is 21, WEEKUM is equivalent to ISOWEEKNUM type  can be other values, which are rarely used. See the official reference if you need to use it. Example