- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
- Features
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
-
Formula Reference
- Formula Overview
-
Formula Functions
- Barcode Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometric Functions
- Statistical Functions
- Sparkline Functions
- Text Functions
- Web Functions
- Other Functions
- RegEx Functions
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
WEEKNUM
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 weeks | |
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.