Usage of the WEEKNUM() formula

Sometimes you may need to calculate how many weeks have passed in this year based on a date.

You can use this formula, WEEKNUM(Date,[return_type]), to calculate.

Date: Date field

Return_type: Optional. A number that determines on which day the week begins. The default is 1.

In the following table are all the return_types that you can use.

Example

Let's say we apply a formula that refers to A2, and the value in A2 is 2020/01/07. The result will be:

WEEKNUM(A2)  ->  2
WEEKNUM(A2, 13)  ->  1