

Make a copy of the example spreadsheet How to Use WEEKNUM Function in Google Sheets You may make a copy of the spreadsheet using the link I have attached below. The date or the first argument should be enclosed between quotation marks for the function to interpret is as the date value: Otherwise, you will get an incorrect result. We mentioned that not providing a value to the second argument is the same as providing 1 as the second argument.Īlso, note that if the first argument is not a reference to a cell where the date value is located, you must enclose the direct value in the WEEKNUM function with the quotation marks. Refer to the table below for the values that you may use as the second argument:Īgain, in the example above, Prim didn’t pass any value to the second argument, which means it will take Sunday as day 1 of the week. It is because the WEEKNUM function will consider the default value of 1 to the return_type argument if no value is provided. Notice in the formula used for each row that there’s only one argument passed to the WEEKNUM function. Let’s take a look at the report that Prim’s created below to see how the WEEKNUM function is used in Google Sheets.

The function will return a #NUM! error if the value passed to return_type argument is not the value permitted by the function.The function will return a #VALUE! error if the given serial_number is non-numeric or cannot be recognized as a valid date.The serial_number argument for the WEEKDAY function should be entered as either a reference to a cell containing a date or a date returned from another function or formula.If no value is passed to the second argument, return_type, it will take the default value of 1.

The rules for using the WEEKNUM function in Google Sheets are as follows:
