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 [...]
