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