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, 2012month
: 2 digits.
For example, 01 or 12day
: 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))