Syntax. GETPIVOTDATAdatafield, pivottable, field1, item1, field2, item2. The GETPIVOTDATA function syntax has the following arguments Datafield Required. For all general questions relating to Excel but not including VBA or formulas. Converting an excel table to flat list. How to create a Excel flat list or file from data that has been formatted as a cross tab or pivot table. Here you will find a detailed tutorial on 100 Excel Functions. Each function is covered in detail with a practical Examples and Video. Excel WEEKNUM Function. Home Excel Built In Functions Excel Date And Time Functions Excel Weeknum Function. Function Description. For a given date, the Excel Weeknum function returns an integer representing the week number from 1 to 5. The syntax of the function is WEEKNUM serialnumber, returntype Where the arguments are as follows serialnumber The Excel date that you want to return the week number for. An optional argument, that specifies which numbering system to be used and which weekday should be treated as the start of the week. I have a pivot table with a date value as one of the columns in the data that I want to use as a report filter. For some reason the dates are showing. The two different numbering systems are system 1     The week containing January 1st is numbered week 1 system 2     The week containing the first Thursday of the year is numbered week 1. The possible values of returntype are returntypeMeaning. Buku Tata Bahasa Indonesia Pdf'>Buku Tata Bahasa Indonesia Pdf. Week runs from Sunday to Saturday Uses numbering system 1. Week runs from Monday to Sunday Uses numbering system 1. Week runs from Monday to Sunday Uses numbering system 1. Week runs from Tuesday to Monday Uses numbering system 1. Pivot-5-1024x546.png' alt='How To Insert Serial Number In Excel Pivot Table' title='How To Insert Serial Number In Excel Pivot Table' />Week runs from Wednesday to Tuesday Uses numbering system 1. Week runs from Thursday to Wednesday Uses numbering system 1. Week runs from Friday to Thursday Uses numbering system 1. Week runs from Saturday to Friday Uses numbering system 1. Week runs from Sunday to Monday Uses numbering system 1. Week runs from Monday to Sunday Uses numbering system 2. If omitted, the returntype argument is set to the default value 1 i. Sunday and numbering system 1 is used. Note that only options 1 and 2 above are available in Excel 2. Note that it is advised that you do not type dates directly into functions, as Excel may interpret text representations of dates differently, depending on the date interpretation settings on your computer. Therefore the serialnumber argument for the Weeknum function should be input as either A reference to a cell containing a date    or. A date returned from another function or formula. Weeknum Function Examples. Column B of the spreadsheet below contains 5 examples of the Excel Weeknum Function. Formulas AB1. Sat 0. Jan 2. WEEKNUM A1 2. Sun 0. Jan 2. 01. WEEKNUM A2 3. Sun 0. Jan 2. WEEKNUM A3, 2 4. Mon 0. 3 Jan 2. WEEKNUM A4 5. Mon 0. Jan 2. 01. WEEKNUM A5, 2  Results AB1. Sat 0. 1 Jan 2. Sun 0. Jan 2. Sun 0. 2 Jan 2. Mon 0. 3 Jan 2. Mon 0. Jan 2. Weeknum Function Example 2. The Excel Weeknum function may be useful if you want to analyse the peak weeks throughout the year for a set of events. Column A of the spreadsheet below records the dates of a set of events, and the Weeknum function is used in column B of the spreadsheet, to show the week number for each event. Formulas AB1. Date. Week No. 2. Tue 0. Jan 2. WEEKNUM A2 3. Wed 0. Jan 2. 00. WEEKNUM A3 4. Wed 0. Jan 2. WEEKNUM A4 5. Fri 0. Jan 2. 00. WEEKNUM A5 6. Mon 0. Jan 2. WEEKNUM A6 7. Mon 0. Jan 2. 00. WEEKNUM A7 8. Wed 0. Jan 2. WEEKNUM A8 9. Sat 1. Jan 2. 00. WEEKNUM A9 1. Sun 1. Nvidia Control Panel Windows 7 32 Bit. Jan 2. WEEKNUM A1. Mon 1. 4 Jan 2. WEEKNUM A1. Mon 1. 4 Jan 2. WEEKNUM A1. Tue 1. 5 Jan 2. WEEKNUM A1. Wed 1. 6 Jan 2. WEEKNUM A1. Wed 1. 6 Jan 2. WEEKNUM A1. Wed 1. 6 Jan 2. WEEKNUM A1. Mon 2. 1 Jan 2. WEEKNUM A1. Mon 2. 1 Jan 2. WEEKNUM A1. Fri 2. 5 Jan 2. WEEKNUM A1. Wed 3. 0 Jan 2. WEEKNUM A2. Sat 0. 2 Feb 2. WEEKNUM A2. Sun 0. 3 Feb 2. WEEKNUM A2. Sun 0. 3 Feb 2. WEEKNUM A2. Mon 0. 4 Feb 2. WEEKNUM A2. Results AB1. Date. Week No. 2. Tue 0. Jan 2. Wed 0. 2 Jan 2. Wed 0. 2 Jan 2. Fri 0. Jan 2. Mon 0. 7 Jan 2. Mon 0. 7 Jan 2. Wed 0. Jan 2. Sat 1. 2 Jan 2. Sun 1. 3 Jan 2. Mon 1. Jan 2. Mon 1. 4 Jan 2. Tue 1. 5 Jan 2. Wed 1. Jan 2. Wed 1. 6 Jan 2. Wed 1. 6 Jan 2. Mon 2. Jan 2. Mon 2. 1 Jan 2. Fri 2. 5 Jan 2. Wed 3. Jan 2. Sat 0. 2 Feb 2. Sun 0. 3 Feb 2. Sun 0. Feb 2. Mon 0. 4 Feb 2. The WEEKNUM data can now be used in an Excel Pivot Table, to show the number of events occurring during each week. A pivot table made up of the above data is shown aboveon the right. The pivot table enables you to clearly see that the peak week for the events is week number 3 1. January, which accounts for a total of 7 events. For further information and examples of the Excel Weeknum function, see the Microsoft Office website. Weeknum Function Errors. If you get an error from the Excel Weeknum function, this is likely to be one of the following Common ErrorsNUM Occurs if either The supplied returntype argument is not one of the permitted values see above table. The supplied serialnumber argument is numeric but is out of range for the current date base. VALUE Occurs if the supplied serialnumber cannot be recognised as a numeric value or a date.