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
datecan 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))