Getting ready

To prepare for this recipe, perform the following steps:

  1. Create a table using the following formula:
R06_Calendar = CALENDAR(DATE(2018,1,1),DATE(2022,12,31))
  1. Create a column in this table using the following formula:
Weekday = FORMAT([Date],"dddd")

The Weekday column is simply for reference and checking; it is not a required part of the recipe.