Hi Renee,

Calculating the Friday before a date can be done using a combination of the

**WEEKDAY** and

**IF** functions in Excel. Here are the steps to follow:

- Assuming your column of dates starts in cell A2, in cell B2, enter the formula:
Formula:

```
``````
=IF(WEEKDAY(A2)=6,A2-1,A2-WEEKDAY(A2)-1)
```

- This formula checks if the weekday of the date in cell A2 is greater than or equal to 6 (which means it's a Saturday or Sunday). If it is, then it subtracts 1 from the date in cell A2 to get the Friday before. If it's not a weekend day, then it subtracts the weekday number from the date in cell A2 (which gives you the previous Friday) and then subtracts an additional 1 to get the Friday before.
- Copy the formula in cell B2 down to the rest of the cells in column B to get the Friday before each date in column A.