WEEK - Returning the Week Number of a Year

text/date/value

Represents the date entered.

"F1"/"F7" (must be uppercase)

Determines the date range for the first week of the year:

• F1 determines that the week containing January 1st is the first week of the year, and the date range is from January 1st to the last day of that week.

• F7 determines that the first complete week is the first week of the year, and the date range is from the start date to the end date of the first complete week.

Note:

1. The Week Start from setting on the decision-making platform determines whether the week begins on Sunday or Monday, which affects the date range of the first week.

2: Currently, only F1 and F7 are supported.If F1 or F7 is not entered, the default value is F7.

Value

52

Starting from Monday, the first complete week is from January 4th to January 10th, so the returned value is 52.

1

1

1

The first week starts from January 1st, so the first week is from January 1st to January 3rd.

2

2

1

Starting from Sunday, the first complete week is from January 3rd to January 9th, so the returned value is 1.

1

1

2

The first week starts from January 1st, so the first week is from January 1st to 2nd and the second week is from January 3rd to 9th.

2

2

WEEK()

52

The corresponding system server time is 2010-01-01 15:36:25.

WEEK("2010/1/1")

52

WEEK("2010/1/1","F1")

1

WEEK("2010/1/6")

1

WEEK(35796)

52