weeknum

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

  • 1 for January 1, 2012
  • 53 for December 31, 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 January 1, 2012, the following function returns 1:
    weeknum(today())
  • The following function returns 53:
    weeknum(date(2013,12,31))

Related links

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
357110937029604375
true
Search Help Center
true
true
true
true
true
5055977
false
false