How can we help?
Full Site Search

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.

Return_type Week begins on
1 or omitted Sunday
2 Monday
11 Monday
12 Tuesday
13 Wednesday
14 Thursday
15 Friday
16 Saturday
17 Sunday
21 Monday


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

Top of Page

    Start Ragic for Free

    Sign up with Google