WEEKNUMBER Function

Returns a number representing the week of the year, 1-52, where 1 is the first week in the year.
Sample Usage
WEEKNUMBER([Due Date]5)
Syntax
WEEKNUMBER(
  • date
)
  • date
    The date from which to return the week of the year.
Usage Notes
  • Smartsheet calculates week numbers based on Mondays. Due to this, the first day of the year may not be in the first week of the year. For example, if January 1st is a Monday, WEEKNUMBER returns 1, however if it’s a Friday, WEEKNUMBER returns 52.
Was this article helpful?
YesNo