Returns a number that indicates where the week falls numerically within a year.
Object Model
Syntax
'Declaration Public Class CalcWeekNumFunction Inherits CalcBuiltinFunction
'Usage Dim instance As CalcWeekNumFunction
public class CalcWeekNumFunction : CalcBuiltinFunction
Remarks
The WEEKNUM function considers the week containing January 1 to be the first week of the year. However, there is a European standard that defines the first week as the one with the majority of days (four or more) falling in the new year. This means that for years in which there are three days or less in the first week of January, the WEEKNUM function returns week numbers that are incorrect according to the European standard.
Inheritance Hierarchy
System.Object
GrapeCity.CalcEngine.Functions.CalcFunction
GrapeCity.CalcEngine.Functions.CalcBuiltinFunction
GrapeCity.CalcEngine.Functions.CalcWeekNumFunction
See Also