FAQ
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_typeWeek begins on
1 or omittedSunday
2Monday
11Monday
12Tuesday
13Wednesday
14Thursday
15Friday
16Saturday
17Sunday
21Monday

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

Top of Page

    Start Ragic for Free

    Sign up with Google