=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 […]
Formula to calculate a date according to the week number. The result is not the same according to the iso week number system
Discover how you can easily find weekends or weekdays with Excel functions. No complex formulas are necessary.