Skip to content

Automatic translation — the Portuguese version is the reference. View in Portuguese

SEMANA

On this page (10)

Week number in the year (the week starts on Sunday).

FieldValue
CategoryDate and time
TypeScalar (operates value by value)
Arity1 argument (fixed)
Compiles to SQL (calculated column)Yes
VersionFormula engine v3.

Aliases#

Canonical name: SEMANA. Accepted aliases (case-insensitive): weeknum, week.

Syntax#

code
SEMANA(expr)

All arguments are expressions.

Returns#

Number.

Null handling#

Invalid or missing dates become a friendly error or blank, depending on the function.

Evaluation context#

Scalar — evaluated on the result of the arguments (in calculated columns, it runs row by row).

Differences from DAX#

  • DAX equivalent: WEEKNUM
  • Compatibility: Compatible with DAX
  • Note: Week starting on Sunday (WEEKNUM type 1).

Examples#

code
SEMANA(pedido_em)

Example with values#

Input: date 2025-06-15.

code
SEMANA(DATA(2025;6;15))  →  24

Expected result: 24

Business example#

Time analysis — order age, accrual month/year, accounting close.

Common errors#

Typos in a column name, an incompatible type, or an invalid argument become a friendly message (pt-BR) — the engine never silently returns a wrong number.


← Back to the formula index

Related links