![]() Here's the formula you'll need to obtain a date's week number:īy default, the return_type argument is taken as 1, which means the week starts on Sundays. In our example, we'll use a date in January so it's easy to manually calculate weeks and verify the output. ![]() Example 1 – Plain Vanilla Formula for the WEEKNUM Functionįor a moment, let's pin the return_type argument aside and focus on how the WEEKNUM function works in its most basic form. Let's try to see some examples of the WEEKNUM function. The function is available in MS Excel 2007 and above.If the code supplied in the return_type argument is any value except the ones mentioned in the table, the function returns a #NUM! error.If the date you supply to the serial_number argument is outside Excel's date base, the function will return a #NUM! error.If the return_type argument isn't specified, it's taken as 1 by default.The value supplied in the serial_number argument must be a valid Excel date.Important Characteristics of the WEEKNUM function The week with the year's first Thursday is week #1 as per ISO 8601 ![]() The week on which January 1 falls is week #1 'return_type' – This is an optional argument where you may enter a value based on which the first week of the year is counted. You could either enter a date value directly or reference a cell containing a valid Excel date. 'serial_number' – This is a required argument where you'll need to supply the serial number representing the date you want to obtain the week number for.
0 Comments
Leave a Reply. |