Text Documents (Writer)
General Information and User Interface Usage
Command and Menu Reference
Navigating Text Documents
Formatting Text Documents
Templates and Styles
Graphics in Text Documents
Tables in Text Documents
Objects in Text Documents
Sections and Frames in Text Documents
Tables of Contents and Indexes
Fields in Text Documents
Calculating in Text Documents
Special Text Elements
Automatic Functions
Numbering and Lists
Spell Checking, Thesaurus and Languages
Troubleshooting Tips
Loading, Saving, Importing, Exporting and Redacting
Master Documents
Links and References
Printing
Searching and Replacing
HTML Documents (Writer Web)
Spreadsheets (Calc)
General Information and User Interface Usage
Command and Menu Reference
Functions Types and Operators
Loading, Saving, Importing, Exporting and Redacting
Formatting
Filtering and Sorting
Printing
Pivot Table
Pivot Chart
Scenarios
Subtotals
References
Viewing, Selecting, Copying
Formulae and Calculations
Presentations (Impress)
General Information and User Interface Usage
Command and Menu Reference
Loading, Saving, Importing, Exporting and Redacting
Formatting
Effects
Objects, Graphics and Bitmaps
Text in Presentations
Drawings (Draw)
General Information and User Interface Usage
Command and Menu Reference
Loading, Saving, Importing and Exporting
Formatting
Objects, Graphics and Bitmaps
Groups and Layers
Text in Drawings
Viewing
Database Functionality (Base)
Formulae (Math)
General Information and User Interface Usage
Charts and Diagrams
General Information
Macros and Scripting
Office BASIC
General Information and User Interface Usage
Command Reference
Guides
Python Scripts Help
General Information and User Interface Usage
Programming with Python
Script Development Tools
Office Installation
Common Help Topics
General Information
Office and Microsoft Office
Office Options
Wizards
Letter Wizard
Fax Wizard
Agenda Wizard
HTML Export Wizard
Document Converter Wizard
Configuring Office
Working with the User Interface
Digital Signatures
Printing, Faxing, Sending
Drag & Drop
Copy and Paste
Charts and Diagrams
Load, Save, Import, Export, PDF
Links and References
Document Version Tracking
Labels and Business Cards
Inserting External Data
Automatic Functions
Searching and Replacing
Guides
WEEKNUM-EXCEL2003
The result indicates the number of the calendar week for a date.
The WEEKNUM-EXCEL2003 function is designed to calculate week numbers exactly as Microsoft Excel 2003 did. Use the WEEKNUM function for ODF OpenFormula and Excel 2010 compatibility, or ISOWEEKNUM function when you just need ISO 8601 week numbers. In releases prior to Office 5.1 WEEKNUM-EXCEL2003 was named WEEKNUM-ADD.
Syntax
WEEKNUM-EXCEL2003(Date; ReturnType)
Date is the date within the calendar week.
ReturnType is 1 for week beginning on a Sunday, 2 for week beginning on a Monday.
Example
In which week number does 2001-12-24 fall?
=WEEKNUM-EXCEL2003(DATE(2001;12;24);1) returns 52.