![]() WEEKDAY: Returns a number representing the day of the week of the date provided.ĭAYS360: Returns the difference between two days based on the 360-day year used in some financial interest calculations.ĭATE: Converts a year, month, and day into a date.ĭATEVALUE: Converts a provided date string in a known format to a date value. For each type, the start day and end day of a week are defined as follows when counting week numbers:.System 2 is the approach specified in ISO 8601, also known as the European system for numbering weeks. System 2 - The first week of the year is considered to be the week containing the first Thursday of the year, which is numbered as week 1.System 1 - The first week of the year is considered to be the week containing January 1, which is numbered week 1.Behind the scenes, there are two week numbering "systems" used for this function:.When inputting the date, it is best to use the DATE function, as text values may return errors. ![]()
0 Comments
Leave a Reply. |