WEEKNUM (PQL - xl)
This function returns a number that indicates the week of the year numerically
- Library: PQL \ Spreadsheet \ Date & Time
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
WEEKNUM(serial number, return type)
Function Arguments
Name | Description | Type | Optional |
|---|---|---|---|
serial number | Date for which you want to determine the number of week | StringOrNumber |
|
return type | Type of week determined by on which day the week starts | Number |
|
Comments
This function is the same as the Microsoft Excel 'WEEKNUM' function - using the same inputs, logic and outputs.