# WEEKNUM(SN, Type)

where,

• represents a date for which week number has to be displayed,
• represents the type of return value.

WEEKNUM() displays a number that indicates where the week falls in a year.

## Description

WEEKNUM(SN, Type)

• and are required arguments.
• is a date value to be entered either in 'date format' or 'dates returned using formulas'.
• If values are invalid, Calci displays #N/A error message.
• is the type of return value. It can be from the following -
Type Description
1 Number from 1(Sunday) to 7(Saturday)
2 Number from 1(Monday) to 7(Sunday)
• If values are invalid, Calci displays #N/A error message.

## Examples

Consider the following example that shows the use of WEEKNUM function:

 10/8/2014 2/10/2013
```=WEEKNUM(A1,1): Calculates the number of the week in the year for date mentioned in A1 and return type '1'. Displays 41 as a result.
=WEEKNUM(B1,2): Calculates the number of the week in the year for date mentioned in A1 and return type '2'. Displays 6 as a result.
=WEEKNUM(DATE(2013,10,28),1) : Calculates the number of the week in the year for date mentioned and return type '1'. Displays 44 as a result.

```