This function calculates the number ISO week number of the year for specified date.

Syntax

ISOWEEKNUM(date)

Arguments

Specify the date argument as a number (as in 37806), a string or reference to cell containg the information.

Data Types

Accepts numeric or string data for both arguments. Returns numeric data.

Examples

ISOWEEKNUM("5/9/2015") gives the result 19.

Version Available

This function is available in Spread for Windows Forms 11.0 or later.