Hello all,

I have been trying to work with the WEEKDAY function, unsuccessfully. I
have a column of dates, I would like to calculate the Friday before the date
please.

Thank you,
Renee

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.

You can use a formula like:
=DATE(YEAR(A1),MONTH(A1),DAY(A1)-MOD(WEEKDAY(A1)-6,7))

The 6 in the MOD(WEEKDAY(A1)-6,7) is the result of the WEEKDAY function on a
Friday, if you have a different setting change it appropiately.

Hope this helps,
Miguel.

"Renee" wrote:

Hello all,

I have been trying to work with the WEEKDAY function, unsuccessfully. I
have a column of dates, I would like to calculate the Friday before the date
please.

Thank you,
Renee

For a date in A1

=A1-WEEKDAY(A1+1)

"Renee" wrote:

Hello all,

I have been trying to work with the WEEKDAY function, unsuccessfully. I
have a column of dates, I would like to calculate the Friday before the date
please.

Thank you,
Renee

Thank you both!

"Miguel Zapico" wrote:

You can use a formula like:
=DATE(YEAR(A1),MONTH(A1),DAY(A1)-MOD(WEEKDAY(A1)-6,7))

The 6 in the MOD(WEEKDAY(A1)-6,7) is the result of the WEEKDAY function on a
Friday, if you have a different setting change it appropiately.

Hope this helps,
Miguel.

"Renee" wrote:

Hello all,

I have been trying to work with the WEEKDAY function, unsuccessfully. I
have a column of dates, I would like to calculate the Friday before the date
please.

Thank you,
Renee