Functions

ISOWEEKNUM

ISO week number of the year for a date

Try it

When to use it

When should I use ISOWEEKNUM instead of WEEKNUM?

Use ISOWEEKNUM when you need ISO 8601 week numbers (week starts Monday, week 1 is the week containing the year's first Thursday), which is the standard used in Europe and international supply chains.

Used in

operations

Syntax

ISOWEEKNUM(date)

Examples

=ISOWEEKNUM(DATE(1969,7,20)) // => 29
=ISOWEEKNUM(DATE(2002,6,14)) // => 24
=ISOWEEKNUM(DATE(2015,1,1)) // => 1

ISODD

Returns TRUE if number is odd

ISPMT

Interest paid for a period (straight line)