On Sun, 14 Jan 2007 08:18:00 -0800, Zsolt Szabó
wrote:

Happy Sunday everybody!
I'm an options trader and in my live the 3rd Friday of the month its
important. If I have in cell A1 a date (opening the account), what formula do
I have to use to see the next 3rd friday date in cell C2 and the next in C3,
C4 etc. Example A1 = 01/14/2007 than in C2 I like to see 01/19/2007 in C3
02/16/2007. Please help me.

C2: =A1-DAY(A1)+22-WEEKDAY(A1-DAY(A1)+2)
C3: =C2+54-DAY(C2+32)-WEEKDAY(C2+6-DAY(C2+32))

select C3 and copy/drag down as far as needed


--ron