Compute the 3rd Friday of the month?

Thanks:  0
Likes:  0

# Thread: Compute the 3rd Friday of the month?

1. ## Compute the 3rd Friday of the month?

I put in the month in a cell A1 of lets say 9/1/2003 or September

In cell B1 I want excel to compute the third Friday of that month which in this case is 9/19/2003

Can that be done?

2. ## Re: Compute the 3rd Friday of the month?

=DATE(YEAR(B1),MONTH(B1),14+CHOOSE(WEEKDAY(DATE(YEAR(B1),MONTH(B1),1)),6,5,4,3,2,1,7))

3. ## Re: Compute the 3rd Friday of the month?

Thanks that worked out

4. you're welcome. i did a sneeky edit for a typo on my original post - if you've got the version that ends ....6)), change it for the one above.

5. ## Re: Compute the 3rd Friday of the month?

how do i find the 1st friday of the month preceding the 3rd wednesday in excel

6. ## Re: Compute the 3rd Friday of the month?

3rd Friday of the month :

=A1-DAY(A1)-WEEKDAY(A1-DAY(A1)+2)+22

Regards

7. ## Re: Compute the 3rd Friday of the month?

I think that the 1st Friday preceding the third Wednesday of the month isn't necessarily the same as the 3rd Friday of the month.

For instance this month the 3rd Wednesday is 17th and the Friday preceding that is the 12th, so to get that result

=A1-DAY(A1)-WEEKDAY(A1-DAY(A1)+4)+17

for any date in A1

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•