3rd Thursday of each month

[msnews.microsoft.com]

I need a formula I can copy down a column that will give the the 3rd
Thursday of each month starting with Thursday, October 21st, 2004. Starting
cell is B10. Any ideas?

Thanks, Will

 

[Sandy Mann]

Will,

Try:-
=(B10-DAY(B10)+32)-WEEKDAY((B10-DAY(B10)+32)-5)+21
and copy down as far as necessary

HTH

Sandy

 

[Myrna Larson]

Given the 3rd Thursday of some month, the next 3rd Thursday will be either 28
or 35 days away. The 3rd occurrence of any given weekday will fall between the
15th and 21st day of the month.

Armed with those 2 pieces of information, you can put this formula in B11, and
copy down:

=IF(DAY(B10+28)<15,B10+35,B10+28)

 

[Sandy Mann]

Ignore my formula it produces errors, go with Myrna's

Sandy