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.