Get Monday of the week

To get the Monday of the week (i.e. the beginning of a week) for any given date, you can use a formula based on the WEEKDAY function. In the example shown, the formula in C6 is: =B5-WEEKDAY(B5,3) Note: In Excel's default scheme, weeks begin on Sunday. However, this example assumes the first day of a week is Monday, which is configured with WEEKDAY's second argument as explained below.