Manuals/calci/WEEKNUM

WEEKNUM (Value,Type)

where,

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

WEEKNUM() converts a serial number to a number representing where the week falls numerically with a year.

Description

WEEKNUM(Value, Type)

• $Value$ and $Type$ are required arguments.
• $Value$ is a date value to be entered either in 'date format' or 'dates returned using formulas'.
• If $Value$ values are invalid, Calci displays #N/A error message.
• $Type$ 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 $Type$ values are invalid, Calci displays #N/A error message.
• We can use Range values also. For Example: WEEKNUM(#10/28/2013-12/28/2013,1)
• #date notation needs mm/dd/yy format .

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.

Related Videos

WEEKNUM

See Also

• WEEKDAY
• WORKDAY

References

• Date Formats
• Date
• Week

• List of Main Z Functions

• Z3 home