=WEEKDAY(Date,Localization) How to use the WEEKDAY function The WEEKDAY function operates with minimal arguments, just a date =WEEKDAY(A1) Yet the returned result may pose confusion. The 13/11/2023 is a Monday and the WEEKDAY function returns 2; WHY? The function, developed by Microsoft, an American company, reflects the U.S. convention where the week starts on Sunday, making Monday the second day. This is why, if you don't use the same US convention for the first day of the week, the results of the WEEKDAY function can insert errors in your report. Explanation of the second argument The second parameter is optional but very useful if you are NOT in USA or Canada. While Monday is the default first day for most countries globally, specifying this argument ensures accurate calendar settings. You can set values for the second argument as follows: The screenshot displays the different results returned for the same date […]