ISOWEEKNUM function

Description

This is the build in function to returns number of the ISO week number of the year for a given date. For example, the formula =ISOWEEKNUM("1/2/2017") returns a number in the Excel base on weeks begining on the default, Mon (5). It is useful when calculating the duration of a time plan in the gantt chart.

​

Objective

Returns number of the ISO week number of the year for a given date.

​

Syntax

=ISOWEEKNUM(date)

​

Arguments

date - Date is the date-time code used by Excel for date and time calculation.

​