Compute the 3rd Friday of the month?

[coccio]

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?

 

[PaddyD]

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

 

[coccio]

Thanks that worked out

 

[PaddyD]

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.

 

[arabs133]

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

 

[bosco_yip]

3rd Friday of the month :

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

Regards

 

[barry houdini]

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