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.
|Return_type||Week begins on|
|1 or omitted||Sunday|
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