Navigation:  Formula Reference > Spreadsheet Formula Functions >

WEEKNUM

Previous pageReturn to chapter overviewNext page

 

This function returns a number that indicates the week of the year numerically.

Syntax

WEEKNUM(date,weektype)

Arguments

This function has these arguments:

Argument

Description

 

date

Date for which you want to determine the number of week

 

weektype

Type of week determined by on which day the week starts

 

 

Value

Number returned

 

1 (assumed if omitted)

Week starts on a Sunday

 

2

Week starts on a Monday

Specify the date argument as a number (as in 37806.5) a string (as in "7/4/2003 12:00"), or a DateTime object, as in DATE(2003,7,4). For more details on the date inputs, refer to Date and Time Functions.

Data Types

Accepts numeric, string, DateTime object, or TimeSpan object data. Returns numeric data.

Examples

WEEKNUM(A2)

WEEKNUM(R2C1,2)

WEEKNUM(23,1) gives the result 4

 

See Also

MONTH

WEEKDAY