Knowledge Base
Got issues? Don't worry, here are all the solutions.

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

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
Learn more about Ragic:
Why we created Ragic
Webinars
User Guide
Ragic Pricing
Applications
Keep in touch:
Blog
Facebook
YouTube
Ragic, Inc.
1-888-666-8037
Terms
Privacy
info@ragic.com