weeknum

Returns the current week number in a year (1 to 54) for the date where weeks start on Sunday. For example, the function returns:

• 1 for 1 January 2012
• 53 for 31 December 2012

Syntax

weeknum(date(year, month, day))

Parameters

• date can be any of the following:
  • Another function that returns a date.
  • A formula column that returns a date.
• year: 4 digits.
  For example, 2012
• month: 2 digits.
  For example, 01 or 12
• day: 2 digits.
  For example, 01 or 30

Examples

• If today is 1 January 2012, the following function returns 1:
  weeknum(today())
• The following function returns 53:
  weeknum(date(2013,12,31))

Related links

• Use functions in custom columns
• day
• month
• year
• weekday
• offset_days
• today
• yesterday
• week_start_sunday
• week_start_monday