Purpose

Return value

Syntax

=ISOWEEKNUM(date)
  • date - A valid Excel date in serial number format.

Using the ISOWEEKNUM function

The ISOWEEKNUM function returns a week number based on ISO standards. Under this standard, weeks begin on Monday and the week number 1 is assigned to the first week in a year that contains a Thursday, following ISO 8601 .

ISOWEEKNUM takes just one argument, date , which must be a valid Excel date.

Examples

In the example shown, the formula in D5, copied down, is:

=WEEKNUM(B5) // default week number

The formula in E5, copied down the table, is:

=ISOWEEKNUM(C5) // ISO week number

By default the standard WEEKNUM function will start week number 1 on the first day of the year, then increment week numbers on Sundays after that. The ISOWEEKNUM function increments on Mondays, and starts week 1 on the first week that contains a Thursday.

The WEEKNUM function can also be configured to output an ISO week number, by setting the return_type argument to 21. The formula below will output the same week numbers seen in column E of the example:

=WEEKNUM(B5,21) // ISO week number

Notes

  • ISOWEEKNUM returns #VALUE! if date is not recognized as a valid date.
  • ISOWEEKNUM returns #NUM! if date is out of range.

Purpose

Return value

Syntax

=MINUTE(serial_number)
  • serial_number - A valid date or time.

Using the MINUTE function

The MINUTE function extracts the minute from a time as a number between 0-59. For example, given a time of “7:45”, MINUTE will return 45. The MINUTE function takes just one argument , serial_number , which must be a valid Excel date or a valid Excel time .

Times can be supplied to the MINUTE function as text (e.g. “7:45 PM”) or as decimal numbers (e.g. 0.5, which equals 12:00 PM). To create a time value from scratch with separate hour, minute, and second inputs, use the TIME function .

The MINUTE function will “reset” to 0 every 60 minutes (like a clock). To work with minute values larger than 60, use a formula to convert time to decimal minutes .

Examples

To use the MINUTE function, supply a time value:

=MINUTE("9:45 AM") // returns 45
=MINUTE("3:10 PM") // returns 10

You can use the MINUTE function to extract the minute into a cell, or feed the result into another function like the TIME function . For example, with the time 5:45 PM in cell A1, you can create a new time that includes 45 minutes like this:

=TIME(7,MINUTE(A1),0) // returns 7:45 PM

Times can be supplied as text (e.g. “7:45 PM”) or as decimal numbers (e.g. 0.5, which equals 12:00 PM). In general, it’s best to use the TIME function to create time values, because it reduces errors.

Note: Excel stores dates and times as serial numbers. For example, the date Jan 1, 2000 12:00 PM is equal to the serial number 32526.5 in Excel. To check that Excel is correctly recognizing a date or time, you can temporarily format the date as a number.

Notes

  • MINUTE will return the #VALUE error if Excel interprets the given date or time as text.
  • Minute values will “rollover” after 60 minutes. You can use a formula to convert time values to decimal minutes .