Fresh Excel Tips

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

1. How to determine the weekend using the WEEKDAY Function
2. Calculate attendance figure in Excel using the COUNTIF function
3. Calculate a person’s age in days using Excel
4. Calculate Using the Function Wizard in Excel
5. How to Use the YEARFRAC function to calculate employees ages