Finding week start and end dates

Many organizations have the concept of week starting and week ending, especially when dealing with time tracking or reporting. This recipe provides a way to calculate the week start and end dates for any date within a calendar year.

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

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

...