Microsoft Excel 2012 For Mac

This article describes the formula syntax and usage of the ISOWEEKNUM function in Microsoft Excel.

• Download Microsoft Office For Mac

Description

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

2018-7-23  微软正式向中国用户发布Office for Mac2011(Office2011)中文版软件，Office 2011 for mac是微软首次发布中文版本的Office for Mac2011产品。微软研发人员表示，Office2011中文版全面兼容Windows和Mac平台，为苹果用户提供Word. Create your best work with Office 365, and get 1 TB of OneDrive cloud storage for your photos and files. The Office experience you know and love, built for your Mac, PC, iOS and Android devices.

Syntax

ISOWEEKNUM(date)

The ISOWEEKNUM function syntax has the following arguments.

• Date Required. Buying microsoft word online for mac. Date is the date-time code used by Excel for date and time calculation.

Remarks

• Microsoft Excel stores dates as sequential numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.

• If the date argument is not a valid number, ISOWEEKNUM returns the #NUM! error value.

• If the date argument is not a valid date type, ISOWEEKNUM returns the #VALUE! error value.

Example

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.

Download Microsoft Office For Mac