Getting ready

To prepare for this recipe, perform the following steps:

1. Create a table using the following formula:

R07_Calendar = CALENDAR(DATE(2018,1,1),DATE(2022,12,31))

2. Create a column in this table using the following formula:

Weekday = FORMAT([Date],"dddd")

3. Create another column in this table using the following formula:

WeekNum = WEEKNUM([Date])

The Weekday and WeekNum columns are simply for reference and checking; they are not a necessary part of the recipe.