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:

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

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