3/14/2024 0 Comments Serial date number![]() This is the ISO week date system that is part of the ISO 8601 date and time standard. In this system, the week traditionally starts on Sunday. The week containing January 1 is considered the 1 st week of the year and is numbered week 1. ![]() In the WEEKNUM function, two different week numbering systems are used: Monday (used in System 2, please see the details below.) Here is a complete list of the return_type values supported in WEEKNUM formulas. If omitted, the default type 1 is used (the week beginning on Sunday). Return_type (optional) - a number that determines on which day the week begins. ![]() This can be a reference to a cell containing the date, a date entered by using the DATE function or returned by some other formula.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |