Syntax

WEEKNUM(when)

Description

WEEKNUM() interprets when (a Text value) as a Date value and returns the week of the year it represents.

Return Value

A Number value: the week number of the year as a number (1 to 53) if found in when or 0 if not.

Did this answer your question?