WEEK NUMBER function

Category:Date and time

English name:WEEKNUM

That makes?

Returns the number of weeks within a year that corresponds to a specified date.

Syntax

WEEKNUM (serial_num, type)

  • num_de_serie (mandatory ): The date from which the week will be determined within the year.
  • type (required ): The starting day of the week [1 = Sunday, 2 = Monday]

Examples

WEEK NUMBER (“ 09/20/2009 ”, 1) = 39
WEEK NUMBER (“ 09/20/2009 ”, 2) = 38

Leave a Comment