How to calculate the weeks of Advent using Excel’s Weekday Function
As a practical task using previously learned functions, the start date of each week of Advent can be calculated easily. Consider that Advent begins on the fourth Sunday before Christmas. Enter in a cell the date of Christmas and use the WEEKDAY function to calculate when each week of Advent begins.
To calculate when the weeks [...]
How to determine the weekend using the WEEKDAY Function
A quick and easy way of figuring out which dates fall on the weekend is by using the WEEKDAY Function in Excel. Another way to tackle this is to use the method explained in our previous article that can be found HERE. The WEEKDAY function returns the day of the week as a number corresponding [...]
