Microsoft Excel Functions & Formulas

Use the WEEKDAY function to calculate the

weeks of Advent

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.

4

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