WEEKNUM

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

Syntax

WEEKNUM(date, weektype)

This function has these arguments:

Argument	Description
date	[Required] Date for which you want to determine the number of weeks
weektype	[Optional] 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).

WEEKNUM(A2)

WEEKNUM(R2C1,2)

WEEKNUM(23,1) gives the result 4.