Use the WEEKDAY function to calculate the weeks of Advent - Date and Time Functions - Microsoft Excel Tutorials

Use the WEEKDAY function to calculate the weeks of Advent using Microsoft Excel

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 of Advent begin for 2006:

1. In cell B2 enter 12/25/2006.
2. Enter in cell B4 this formula to find the first week of Advent: =B2-(WEEKDAY(B2,2))-21.
3. Enter this formula in cell B5: =B2-(WEEKDAY(B2,2))-14.
4. Enter this formula in cell B6: =B2-(WEEKDAY(B2,2))-7.
5. Enter this formula in cell B7: =B2-(WEEKDAY(B2,2)).

Use the WEEKDAY function to calculate the weeks of Advent